AutoHotkey Community

[Jeremiah]

I am having trouble getting this to work. So far, the script does create the file "test.xlsx" and opens it, but for some reason Excel doesn't like it. Any thoughts?

[Jeremiah]

Anyone?
_________________
-Jeremiah

[Carcophan]

I use:

FileAppend,`n%var% `, %var% `, %var% , C:\path\path\ExcelDocuments.csv


the `, is for the comma, as 'CSV' is comma seperated variables, and inputs values into the different columns.

the csv files open with XLS.

[SoLong&Thx4AllTheFish]

Excel files are binary files which you can deal with in AHK as such (you can but you don't want to go there). FileAppend works for text files, like CSV for example. So you could export your Excel file to CSV and add data to it via the fileappend command but it won't work for XLS files.

If you do want to work with Excel files directly you need to look into COM
http://www.autohotkey.com/forum/viewtopic.php?t=31923
_________________
AHK Wiki FAQ
TF : Text files & strings lib, TF Forum

[answer4u]

[engunneer]

xlsx files are actually zip files. One of the better MS standards is the zip container file formats. Rename an xlsx file to .zip, then open it up and have a look. inside you can find all your data in xml format, though it's not always easy to read.


as far as making files, csv is really the right way to go. any spreadsheet program will read it, and all your data will import cleanly.

remember to put "" around text fields. commas inside " are read as commas and not column separators.
_________________

(Common Answers)

[Carcophan]