_ExcelBookSaveAs not creating files

[bootybay]

I just wanted to try exmaple 1 but there is no .xls file created. Even if i use "C:TestTemp.xls" instead of that @TempDir path it doesn't save anything.

#include <Excel.au3>

Local $oExcel = _ExcelBookNew() ;Create new book, make it visible

_ExcelWriteCell($oExcel, "I Wrote to This Cell", 1, 1) ;Write to the Cell

MsgBox(0, "Exiting", "Press OK to Save File and Exit")
_ExcelBookSaveAs($oExcel, @TempDir & "\Temp.xls", "xls", 1, 1) ; Now we save it into the temp directory; overwrite existing file if necessary
_ExcelBookClose($oExcel) ; And finally we close out

I'm missing something but I can't see what.

[water]

Don't know what is wrong but you need to add some error checking to your script.

Every function sets the returnvalue or macro @error in an case of an error. The help file explains what to check.

[bootybay]

I was hoping that the example would work. I was looking at this:

http://www.autoitscript.com/autoit3/docs/libfunctions/_ExcelWriteCell.htm

[water]

You need to povide more information:

Which version of Excel do you run?

Which version of AutoIt do you run?

[water]

The example you provided in post #1 runs fine here and creates the Excel file.

What is the value of @TempDir?

[bootybay]

You need to povide more information:

Which version of Excel do you run?

Which version of AutoIt do you run?

 

You already solved the mystery. I didn't know I needed Excel since I work with google docs. I thought it would just create a spreadsheet and I would just import it.

Thank you for helping me out.

May I use OpenOffice or do I need Microsoft Excel for this?

PS: @TempDir isn't the problem its value is the standard C:Users***AppDataLocalTemp and I tried fixed paths aswell already.

[water]

To run the Excel UDF you need MS Excel installed.

There is an OpenOffice Calc UDF available on the forum. But I'm not familiar with it.

There are UDFs available on the forum to read/create Excel files without having Excel installed.

I might provide further information if I know which route you want to take.

[bootybay]

I'm interested in the nonExel UDFs.

 

I'm confident that I would be able to work with the Excel.au3 if I wanted to install Office.

[water]

Reading XLSX files: >www.autoitscript.com/forum/topic/145160-xlsxreadtoarray-using-only-autoit

Create XLSX files: '?do=embed' frameborder='0' data-embedContent>>

You could use ADO. This means an Excel workbook is treated like a database: