how to save an an excel file as a table (script)?

[salshaw749]

Hey everone,

I'm wondering are ther any war to save an excel file as a table? so i can process it?

I've tried this method

myFrames[0].place(File("......xlsx"), myProperties);
	myFrames[0]= myFrames[0].texts.everyItem().convertToTable('\t')

but i can't used the table properties, for instance: 

for (i=0; i<table.cells.length; i++)
{
if (table.cells[i].texts[0].length == 0)
table.cells[i].fillColor = 'Red';
}

so are there any way to save the file as table dirctly?

*i'm using javascript

[Laubender]

After placing the Excel file check if a table was done by placing the Excel file.

If not, for whatever reason, check if text is placed in the frame. If that's the case convert the text to a table.

What happens after you placed the Excel file? Is there a new table? Is there new text?

Could you show a screenshot of the page where myFrames[0] is positioned.

I assume and hope, that variable myFrames[0] points to an empty text frame that is not threaded to other text frames.

Regards,
Uwe Laubender

( ACP )