Oh, I have just come across the question. I suggest you go to this page for information, it aims at the operation to Excel and export data for XLS, I think it may help you: http://www.e-iceblue.com/Knowledgebase/Spire.XLS/Demos/VBA.html[^] http://www.e-iceblue.com/Knowledgebase/Spire.DataExport/Demos/Cell.html