topic Excel cell format in Discussions

Excel cell format

SeasonalControl — Wed, 21 Feb 2024 08:37:52 GMT

Hello

I'm encountering an issue with inconsistent cell formatting across multiple Excel files. I've written a script that imports all Excel files within a specific folder and then creates a new table with selected data from these files. However, I'm running into a problem because some of the Excel files have cells formatted as 'General', while others are formatted as 'Number'. This discrepancy in formatting, particularly with decimal places, leads to errors when comparing identical files. I'm looking for a solution to standardize the formatting during the import process in JMP, rather than manually adjusting the format in Excel.

Re: Excel cell format

jthi — Wed, 21 Feb 2024 09:56:48 GMT

You might be able to modify the format from excel wizard. Right click on the column name and change the format to Character

And you might get something like this to your import script

Column Numeric Format(Index(0), Column Name(Date), Datatype("Character"))

Re: Excel cell format

Jed_Campbell — Wed, 21 Feb 2024 15:34:25 GMT

I've written a script that imports all Excel files within a specific folder and then creates a new table with selected data from these files.

In your script, are you already using the Multiple File Import () function? If not, that might be helpful.