In SMExport I added two important features:
– TSMExportToXLSX component supports the merge. You may export a few datasets on different sheets in same xlsx-file
– new TSMExportToExcelXML component generates the Excel XML file. Low memory usage and high speed for large datasets
Today I added the new feature in SMExport – to create the xml file from dataset which is compatible with ADO.NET.
Small sample code:
smeXML := TSMExportToXML.Create(nil);
try
smeXML.DataSet := ClientDataSet;
smeXML.ColumnSource := csDataset;
smeXML.FileName := ADOXMLFileName;
smeXML.AddTitle := True;
smeXML.Format := xmlADO;
smeXML.XMLTags.RowTag := 'z:row';
smeXML.DataFormats.CustomDateTimeFormat := 'yyyy-mm-ddThh:nn:ss';
smeXML.Execute;
finally
smeXML.Free;
end;
Today I added the new feature for TSMExportToHTML component – the possibility to generate the html file with embedded images. Unfortunately the old IE (5/6) do not support this feature but FireFox, Opera, Safari will open the file without any problem
A few links:
http://www.sweeting.org/mark/blog/2005/07/12/base64-encoded-images-embedded-in-html
http://rifers.org/blogs/gbevin/2005/4/11/embedding_images_inside_html
Note: large images will not displayed due some limits in browser for encoded string
In SMExport I added the new component to support the JavaScript Object Notation
The format of generated samples are available at http://www.json.org/example.html
For example:
{
“RECORD”: {
“Species No”: 90020
“Category”: “Fish”
“Common_Name”: “CommonFish 828”
“Species Name”: “Fish 275”
“Length (cm)”: 50
“Length_In”: 19,6850393700787
}
}
The dates encoded as the number of milliseconds since January 1st 1970. See the topic for this subject at
http://weblogs.asp.net/bleroy/archive/2008/01/18/dates-and-json.aspx
The binary values encoded in Base64 (same as in xml)
Created the new TAction for export support. Will be included in next SMExport