vfpx / excelxml Goto Github PK
View Code? Open in Web Editor NEWConvert a Table or a Grid control into a Microsoft Excel XML Spreadsheet file
Convert a Table or a Grid control into a Microsoft Excel XML Spreadsheet file
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 :-)
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.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.