hello:
My code:
uses BIFFRecsII4,XLSFonts4, XLSReadWriteII4;
procedure TForm1.btn1Click(Sender: TObject);
begin
xls1.Version := xvExcel2007;
xls1.Sheet[0].AsInteger[1,1] := 90;
xls1.Filename := 'c:\aa.xlsx';
xls1.Write;
xls1.Read;
end;
xlsreadwrite version 4.0.0.X
Error Info: "Zlib decompress error"
It createed 'c:\aa.xlsx' file, but I can not open by Excel 2007 ?
Help!
Create bad Excel 2007 .xlsx File (Zlib decompress error)
Create bad Excel 2007 .xlsx File (Zlib decompress error)
Last edited by vga on Sun Oct 23, 2011 11:57 pm, edited 6 times in total.
Re: Create Excel 2007 File Error!!
How to create a Excel 2007 File?
Re: Create Excel 2007 File Error!!
with the new version 4.0049 I could not create a good .XLSX file too.
procedure TForm1.btn1Click(Sender: TObject);
begin
xls1.Version := xvExcel2007;
xls1.Sheet[0].AsInteger[1,1] := 90;
xls1.Filename := 'c:\aa.xlsx';
xls1.Write;
end;
it did create 'c:\aa.xlsx' file, but
xls1.Read;
can not work.
procedure TForm1.btn1Click(Sender: TObject);
begin
xls1.Version := xvExcel2007;
xls1.Sheet[0].AsInteger[1,1] := 90;
xls1.Filename := 'c:\aa.xlsx';
xls1.Write;
end;
it did create 'c:\aa.xlsx' file, but
xls1.Read;
can not work.
Re: Create Excel 2007 File Error!!
Hello
I can't find any problem with your code.
I can't find any problem with your code.
Lars Arvidsson, Axolot Data
Re: Create Excel 2007 File Error!!
my ide: delphi xe xlsreadwriteII 4.00.52
procedure TForm1.btn1Click(Sender: TObject);
begin
xls1.Version := xvExcel2007;
xls1.Sheet[0].AsInteger[1,1] := 90;
xls1.Filename := 'c:\aa.xlsx';
xls1.Write;
xls1.read;
end;
it did create 'c:\aa.xlsx' file, but when run to:
xls1.Read;
error occur: "Zlib decompress error"
procedure TForm1.btn1Click(Sender: TObject);
begin
xls1.Version := xvExcel2007;
xls1.Sheet[0].AsInteger[1,1] := 90;
xls1.Filename := 'c:\aa.xlsx';
xls1.Write;
xls1.read;
end;
it did create 'c:\aa.xlsx' file, but when run to:
xls1.Read;
error occur: "Zlib decompress error"
Re: Create Excel 2007 File Error!!
[quote="larsa"]Hello
I can't find any problem with your code.[/quote]
which IDE version?
In delphi XE, the followinf code always says: "Zlib decompress error"
procedure TForm1.btn1Click(Sender: TObject);
begin
xls1.Version := xvExcel2007;
xls1.Sheet[0].AsInteger[1,1] := 90;
xls1.Filename := 'c:\aa.xlsx';
xls1.Write;
xls1.read; // run to here, error occur: "Zlib decompress error"
end;
I can't find any problem with your code.[/quote]
which IDE version?
In delphi XE, the followinf code always says: "Zlib decompress error"
procedure TForm1.btn1Click(Sender: TObject);
begin
xls1.Version := xvExcel2007;
xls1.Sheet[0].AsInteger[1,1] := 90;
xls1.Filename := 'c:\aa.xlsx';
xls1.Write;
xls1.read; // run to here, error occur: "Zlib decompress error"
end;