Axolot Data

Thank you. It works well for excel 2007, but for excel 2003, the referenced sheet index of the Name is not matched unless apply the workaround below. xlsName := xlsApp.Names.Find('name_' + sn); if xlsName <> nil then begin xlsName.Definition := '''' + xlsSheet.Name + '''!$A$'+inttostr(j+1)+':$' + Ge...

Hi, I have a excel file, there is a Name "resultset1" defined, then i use following code to update the Area of the Name, but it seems no changed. Can you help me on this? thanks! xlsName := xlsApp.Names.Find('resultset' + inttostr(L+1)); if xlsName <> nil then begin xlsName.Area.SheetIndex...

Thanks Larsa. Then i tried it in XLSReadWriteII 5, it seems okay, am i right? var xlsApp: TXLSReadWriteII5; fs: TFileStream; begin xlsApp := TXLSReadWriteII5.Create(nil); try fs := TFileStream.Create('C:\Users\Benny\Desktop\test.xls', fmOpenRead); try xlsApp.LoadFromStream97(fs); xlsApp.SaveToFile('...

Hi,

Is it possible to convert a xls file (created in excel 2003) to xlsx file by using XLSReadWriteII 4? Thanks in advance.