question

Mischa Spelt avatar image
0 Likes"
Mischa Spelt asked Phil BoBo answered

Is excelgetrangesheet broken?

Hi,

The following code gives me an error "Unable to get MyData range's sheet name".

int isOpen = excelopen( "P:\\Support\\test.xlsx" );
if(isOpen) 
{
	string sheetName = excelgetrangesheet( "MyData" );
	excelclose(0);
	return sheetName;
}
else
{
	return "Could not open workbook.";
}

I used this spreadsheet for testing and expected to get "TestSheet" back: testxlsx.zip.

Am I correct that this is a bug?

FlexSim 18.0.2
excel interface
testxlsx.zip (13.7 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

·
Phil BoBo avatar image
3 Likes"
Phil BoBo answered

Yes, this is a bug. I'll add a case to the dev list.

This command broke when we updated the Excel commands in 16.0.

5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.