Excel XML UDF v1.-1 [UPDATE 19/10/2012]

[FireFox]

Update :

Version 1.0.0.1
Optimized whole code, added redim step var.

Hi,
I had to create Excel files for my needs, but I wondered how to do it because xlsx files are not raw editable; so I searched for a way do it.

Excel can open multiple files type, and the XML is a good way to do it so here it is.

It creates an Excel XML file, with which you will be able to :
-Create Rows
-Create Cells and set it's color
-Set column width
-Set global text horizontal align
-Set XML author
-Set XML creation date
-Set XML compagny

And of course you can easily add features.

Here is an example :

#include "Excel_XML.au3"

$iRow = _ExcelXML_Row_Add()

_ExcelXML_Column_SetWidth(1, 100)
_ExcelXML_Cell_Add($iRow, "Row 1, Cell 1")

_ExcelXML_Column_SetWidth(2, 200)
_ExcelXML_Cell_Add($iRow, "Column width set to 200px")

$iRow = _ExcelXML_Row_Add()
$iCell = _ExcelXML_Cell_Add($iRow, "Cell color red")
_ExcelXML_Cell_SetColor($iCell, 0xFF0000)

_ExcelXML_Cell_Add($iRow, "Excel XML UDF")

$hFile = FileOpen(@ScriptDir & "\Excel_XML test.xml", 2)
FileWrite($hFile, _ExcelXML_Assemble())
FileClose($hFile)

_ExcelXML_Destroy()

And what you are waiting for : Excel_XML.au3
(Previous : 53 downloads)

Enjoy !

Edited November 1, 2013 by FireFox

[FireFox]

@everybody

New version available. (see first post for update)

Br, FireFox.

[JScript]

Although I did not understand anything Excel, thank you for sharing with us!

JS

[FireFox]

@JScript

You're welcome !

I have some ideas, but It will take time to realize them, and I have not so much time for the moment.

Br, FireFox.

Edited October 19, 2012 by FireFox

[Zoldex]

Thanks!

It looks useful.

[geometer]

I have not tested your udf, but i have seen an other udf from jerome that you can find here (). Would it be helpfull to combine this 2 UDF to one?

[FireFox]

@geometer

oh, I did not know this one.

Since his does more than mine, I don't see how it can be possible to combine them. Furthermore I make my projects by myself and this UDF must remain simple.

Br, FireFox.

[arqstaad]

thank you very much, it is a great job!

[yahaosoft]

thanks for share the code!

[jdelaney]

Awesome, I just realized, recently, all the ways to read/write excel without the app...I think that there could be some major improvements using object microsoft.xmldom...I'll look into this later, but great example.

Edited October 31, 2013 by jdelaney

[FireFox]

jdelaney,

Thanks, if you find a way to work with the xmldom object then create a new topic to post your UDF

You can link it here if you want.

Br, FireFox.

Edited November 1, 2013 by FireFox

[jdelaney]

all set: '?do=embed' frameborder='0' data-embedContent>>

I'm having some namespace issues...where new cells and rows, when you load a file, include empty namespaces, causing excel to not display their data...outside of that, the basics are there

[mLipok]

I was working with this UDF for a while.

 

Here are some links for documentation:
OfficeTalk: Dive into SpreadsheetML (Part 1 of 2)

Introduction to Excel XML

Introduction to Excel XML Part 1: creating a simple table

Understanding the Open XML file formats

https://en.wikipedia.org/wiki/Microsoft_Office_XML_formats