AutoHotkey Community

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?


I have also tried this with putting in some text too, but it still doesn't work.

Thank you in advance!

_________________
-Jeremiah

Anyone?

_________________
-Jeremiah

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.

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 FAQ
TF : Text files & strings lib, TF Forum

Try opening a .xlsx file with notepad and you might see why . As Carcophan pointed out, you could convert these files to .csv files, or you could open them with excel to append.

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) - New Tutorials Forum - Humongous FAQ

...wow

Neat trick, had absolutly NO idea that was even possible.