Excel layout

[erikkn]

Hi all,

I'm using AutoIT for tree weeks now and I made a program that export data to a excel sheet. I am curious if there is a possibility that my data is placed into a table with colors, and many of this tings.

Thank you!

 

[water]

Welcome to Autoit and the forum!

Sure this is possible. Unfortunately the Excel UDF that comes with AutoIt (or my rewrite of the UDF) do not provide many functions to format data.

I suggest:

• Start the macro recorder in Excel
• Do all the formatting you need
• Post the created VBA macro and I will help to translate it to AutoIt

[erikkn]

Great thank you so mutch! I will do it and post it next week

[erikkn]

Hi water,

I don't know what to do, I will explain my dream to you, maybe you can help me:

My plan is to make a checklist program with a GUI. A guy called SDK made a script and I used and changed it a little bit. (I added this script here)

So if you start the program you will see a Graphic Interface. On the menu tab I can add a new checklist and answer some question. When I am finished I go back to Menu and save/export this to an excel file.

Okay here we go, the checklist have to be saved with a nice layout, not plain text. I added a file: layout.xlsx ,and my wish is that the exported checklist has the layout of that file. I also made a macro where you asked for. So, everytime you make a checklist and export this, there must be automatic made a new excel file with the data of the checklist  and in the layout of 'layout.xlsx'.

I'm sorry for my bad English , but do you understand me?

Can you help me with this, I am working on this for four weeks now, and it's really drives me crazzy

Thank you water,

Ciao ;-)

test.au3

macro.txt

layout.xlsx

Edited March 18, 2014 by erikkn

[water]

I would open layout.xlsx as a template, insert the data from your GUI in colums B and C and then save the workbook with a different name.

[erikkn]

Can you give me a hint (script) how I can do that automatic?

[water]

Download my rewrite of the Excel UDF.

Thi is an untested example:

$oExcel = _Excel_Open()
$oWorkbook = _Excel_BookOpen($oExcel, "C:\temp\layout.xlsx")
_Excel_RangeWrite($oWorkbook, $oWorkbook.ActiveSheet, $aTable1, "B3") ; Write first part
_Excel_RangeWrite($oWorkbook, $oWorkbook.ActiveSheet, $aTable2, "B10") ; Write second part
_ExcelBookSaveAs(...)
_Excel_BookClose($oWorkbook)
_Excel_Close($oExcel)

[erikkn]

Thank you water, I will test this. May I ask for your help if i got a prob?

[water]

Sure