lavascript Posted March 1, 2013 Share Posted March 1, 2013 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. Link to comment Share on other sites More sharing options...
water Posted March 1, 2013 Share Posted March 1, 2013 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
lavascript Posted March 1, 2013 Author Share Posted March 1, 2013 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. Link to comment Share on other sites More sharing options...
water Posted March 1, 2013 Share Posted March 1, 2013 You can create Excel files without having Excel installed if My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
lavascript Posted March 1, 2013 Author Share Posted March 1, 2013 That's great! Thanks! Link to comment Share on other sites More sharing options...
DXRW4E Posted March 1, 2013 Share Posted March 1, 2013 or (not needed that Office is installed) Link to comment Share on other sites More sharing options...
water Posted March 1, 2013 Share Posted March 1, 2013 My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now