topic Re: Reading Excel file - column with numeric and character values in Discussions

Reading Excel file - column with numeric and character values

gfirmstone — Sat, 10 Jun 2023 23:53:01 GMT

I am reading Excel file with JSL, first 2000 rows of column are numeric, followed by rows with characters. How do I make sure the column is read as character?

Re: Reading Excel file - column with numeric and character values

txnelson — Thu, 11 Aug 2022 21:09:30 GMT

One of the Excel input options that can be specified is

Scan Whole File

Specifies how long JMP scans the file to determine data types for the columns. This is a
Boolean value. The default value is true; the entire file is scanned until the data type is
determined. To import large files, consider setting the value to false, which scans the file for
five seconds.

Scan Whole File is the default.

Re: Reading Excel file - column with numeric and character values

Georg — Fri, 12 Aug 2022 08:51:38 GMT

Hi @gfirmstone , another option would be to directly specify character datatype for that column, see https://community.jmp.com/t5/Discussions/Force-Excel-Import-Wizard-to-Use-Character-for-All-Columns/m-p/460732.

Re: Reading Excel file - column with numeric and character values

gfirmstone — Fri, 12 Aug 2022 12:25:32 GMT

Thank you so much, that worked perfectly! Really appreciate it.