Highlighted

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

Participant ,
Jul 23, 2020

Copy link to clipboard

Copied

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

TOPICS
Bug, Feature request, How to, Import and export, InCopy workflow, Scripting, SDK, Server developers, Type

Views

42

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

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

Participant ,
Jul 23, 2020

Copy link to clipboard

Copied

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

TOPICS
Bug, Feature request, How to, Import and export, InCopy workflow, Scripting, SDK, Server developers, Type

Views

43

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jul 23, 2020 0
Adobe Community Professional ,
Jul 23, 2020

Copy link to clipboard

Copied

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 )

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 23, 2020 0