Jump to content
Sign in to follow this  
lavascript

Export data as .xls or .xlsx

Recommended Posts

lavascript

I have a script that grabs data, processes it, and exports the results as a CSV. Cuz CSV is EASY. ;)

But it's only a 4-column CSV, and by default, Excel displays really narrow columns that need to be resized to see all the data. Bottom line, I'd really prefer to export this data as something more robust than CSV.

Now, as far as I'm aware, there's no spreadsheet equivalent to RTF, is there?

How feasible would it be to actually get this data into a formatted Excel file?

I'm aware that .xlsx is basically a bunch of zipped XML files, so I'm currently trying some reverse engineering there, I just didn't know if I might just be spinning my wheels.

Thanks.

Share this post


Link to post
Share on other sites
water

Use the Excel UDF that comes with AutoIt to write your data to Excel. Then format the columns and save the workbook.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites
lavascript

Well, obviously I looked into the Excel UDF, but I didn't want to actually open Excel in order to generate the file. But the more I think about it, it's really not a bad solution.

Thanks.

Share this post


Link to post
Share on other sites
water

You can create Excel files without having Excel installed if


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites
DXRW4E

or (not needed that Office is installed)


apps-odrive.pngdrive_app_badge.png box-logo.png new_logo.png MEGA_Logo.png

Share this post


Link to post
Share on other sites
water
:D

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×