Style Retain in InDesign to XL

[Sudha_K]

Hi,

     I am exporting the contents from InDesign to XL file. When exporting to xl, contents only written without format.

     How to write the XL file from inDesign with styles formats (eg., italic, bold etc).  If I copy paste from InDesign to XL as manually, it does not capturing the style.  How to do it using script?

[Jongware]

When asking strangers for help clarity is key. Personally I was not immediately familiar with the possibility of export to XL, so to be sure I started up the very latest version of InDesign (CC 2019) and checked if it was available.

There is no "export to XL" feature. Googling did not turn up anything either.

Since this is the Scripting forum, I also checked https://www.indesignjs.de/extendscriptAPI/indesign-latest/#ExportFormat.html ; no format is called "XL".

[Sudha_K]

Hi,

     Sorry for not giving clarity on my question.

     Actually i want to write the contents from InDesign to XL with format.  In InDesign scripting there is no XL format export. Manually I copied and pasted it into XL but no format is retained in XL.  Is there any way to do this process?

[Laubender]

Do you mean XML perhaps?

Regards,
Uwe

[Sudha_K]

No.. Just a copy paste contents from InDesign to XL file is the process.  when copy paste the contents need to retain the style like bold italic but its not possible in manual.  Looking is there is anyother method is there to do..

[Manan Joshi]

[Jongware]​ meant to ask what is this format that you are talking about? Do you intend to say excel format and writing it as XL?

-Manan

[Laubender]

Or do you mean Extra Large ( XL ) whatever that exactly means?

Do you want to scale contents from small to extra large ?

Regards,
Uwe

[Sudha_K]

Hi,

     Sorry...

     1. Find the content from InDesign file using styles.

     2. Write the found text into Excel file (Microsoft Excel).

     3. I need to retain the styles like bold, italic etc in Excel file.

[Laubender]

Export the formatted text to HTML and open the HTML file with Excel.

Regards,
Uwe

[Sudha_K]

If I export HTML format in InDesign, css file folder also exporting.  I tried to open html file in Excel application but i got the below error.

Html exported Folder :

Error when open in Excel

If I click "OK", file is opened in Excel without formatting.

Output :

Format in InDesign:

[vamitulTF]

You can actually write your own export to OpenXML spreadsheet format:

XML Spreadsheet Reference | Microsoft Docs

[Sudha_K]

Hi,

    Using this can we export from InDesign?

[Laubender]

Hi,

I could export HTML with CSS and Excel 2011 on Windows 10 could open this without any issues:

Selection of formatted text:

Opened with Excel 2011 on Windows 10:

Regards,

Uwe

[Sudha_K]

Hi,

     Thank you...

     Is it only work on window 10? Any other OS/ window version will support??

[Laubender]

No idea. What's your version of Excel on Mac OS X ?

Regards,
Uwe

[Sudha_K]

Excel 2011 in Mac OSX..

[Sudha_K]

Hi,

     How to open html file in XL and save it as XL file using applescript? I tried using the below code but not saving in the given name.  Its name showing like "Workbook9".  I want to save it the same name of html file name.

Code:

set htmlFilePath to "PathToHtml.html"

set xlFilePath to "PathToXlsx.xlsx" as POSIX file

tell application "Microsoft Excel"

    open htmlFilePath

    set wkBook to active workbook

    save workbook as wkBook filename xlFilePath with overwrite

    close active workbook   

end tell

[BarlaeDC]

Hi,

What program creates a XL file, do you mean Excel? until we know what you are heading for we will not be able to help you.

Regards

Malcolm