vfpx / excelxml Goto Github PK

Hello,
It seems that the property 'Number' is not initialized in the 'Version' Object.

Doug - this project is only a single VCX. I request that it be converted to a single PRG file so it can be more easily maintained with updates from the community. I have a fix I need to apply, but it will be hard to merge my pull request into the main project because of the VCX.

I'm sure some people may have subclassed from the VCX to their own local environment, and converting to a PRG will break that, but man... We've got to get away from VCXs in our community so updates can happen more easily.

I you approve, I'll fork this project, and I can export it to a PRG, then submit a pull request.

The function ConvertXmlToXlsx refuses to work if the extension is not equal .xml but may be something like .XML .Xml

my row -
If (".XML" $ upper(m.tcFilename))

In the Save() method of ExcelXML it calls a function named IsObject() -- that function doesn't exist :-)

Hello,
The encoding of the generated xml file is ANSI and has a problem with the Persian font.

Can I change it to UTF-8 or UNICODE?

I saw the discussion about moving from vcx to prg for easier maintaining. Please include then in desription the description of the way to use it.
When you use vcx - it's crystal clear: drop the component on the form and then use its methods as described in instruction. But using prg is not so obvious.

Good afternoon;
I have tried to implement this procedure but I cannot do it, you can provide some example
Thank you

Some captions in some column headers in my VFP apps grids are lengthy but they have their "WordWrap" property set to .T. :

When exported to Excel it looks like this:

I suggest you set "Adjust text to cell", when exporting, in all the corresponding column hedaers in the exported Excel, like this:

I guess that helps the user to understand the captions in the Excel file.

Thanks in advance,

Luis Guerra

Hello,
I found a mistake related to the conversion from the VCX class to a PRG.
When calling the NewObject, it still have the reference to ExcelXML.VCX in the sample code
Best regards.
David

*SET PROCEDURE TO ..\excelxml.prg

local loExcelXML, llOk
*loExcelXML = newobject("ExcelXML","ExcelXML.VCX")
loExcelXML = newobject("ExcelXML","..\ExcelXML.prg")

loExcelXML.SheetName = "Students Grade 5A"
loExcelXML.OpenAfterSaving = .t.
llOk = loExcelXML.Save("Sample05.XML")

I got sometimes the "Record out of range" error message when running ExcelXML. It turns out that the variable "lnRecNo" is not getting the RECNO() from the grid's RecordSource. I just found out that it's getting the RECNO() from the cursor that is currently selected when calling ExcelXML.Save() method. The problem is the folowing program line:

lnRecNo = Recno()

To fix this, the preceeding line should be:

SELECT (This.Alias)

And that would be enough to avoid that pesky error message.