topic Re: Trying to open an xlsm excel sheet in Discussions

Trying to open an xlsm excel sheet

BTeague — Fri, 09 Jun 2023 16:02:17 GMT

I am trying to use an open command to open an excel file. I keep getting the error that it can not be opened in the excel wizard. Should I change the worksheet settings?

dt = Open(
	DXrelease,
	Worksheets( "SDMA" ),
	Use for all sheets( 1 ),
	Concatenate Worksheets( 0 ),
	Create Concatenation Column( 0 ),
	Worksheet Settings(
		1,
		Has Column Headers( 1 ),
		Number of Rows in Headers( 1 ),
		Headers Start on Row( 4 ),
		Data Starts on Row( 5 ),
		Data Starts on Column( 1 ),
		Data Ends on Row( 0 ),
		Data Ends on Column( 0 ),
		Replicated Spanned Rows( 1 ),
		Replicated Spanned Headers( 0 ),
		Suppress Hidden Rows( 1 ),
		Suppress Hidden Columns( 1 ),
		Suppress Empty Columns( 1 ),
		Treat as Hierarchy( 0 ),
		Multiple Series Stack( 0 ),
		Import Cell Colors( 0 ),
		Limit Column Detect( 0 ),
		Column Separator String( "-" )
	)
);

Re: Trying to open an xlsm excel sheet

Thierry_S — Sat, 12 Nov 2022 21:06:02 GMT

Hi,

I wonder if the fact that your Excel file is a Macro-Enable file (xlsm extension) causes the problem. Have you tried to save the data file as a standard (i.e., xlsx) file?

If the problem persists, you may want to share the problematic file with us.

Best,

Re: Trying to open an xlsm excel sheet

jthi — Sat, 12 Nov 2022 21:36:53 GMT

Also which JMP version are you using? JMP might have had some changes made how different excel files can be handled with version 16

Re: Trying to open an xlsm excel sheet

BTeague — Sun, 13 Nov 2022 20:18:56 GMT

I haven't but I will try that.

Re: Trying to open an xlsm excel sheet

BTeague — Sun, 13 Nov 2022 20:19:08 GMT

I'm using 16.2

Re: Trying to open an xlsm excel sheet

BTeague — Sun, 13 Nov 2022 21:20:19 GMT

I found the issue! I had the file path name wrong. Nothing wrong with the actual code. Thank you!