PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → [WB19]Opening Excel File
[WB19]Opening Excel File
Iniciado por guest, 23,mar. 2016 07:23 - No hay respuesta
Publicado el 23,marzo 2016 - 07:23
Hallo

I want to open an Excel file of about 32MB in Webdev 19 but keep getting a GPF at the fOpen command.

Other, smaller files are opened without problems

In Windev 19 the file is opened after about 20+ seconds but at least the application continues.

Two questions:

Is there an issue opening files over a certain size in Webdev and is there a way around it?

Is there a way in the application to delay the code to execute after the file is opened until the file is opened?

My code is:

IDXLSFile = xlsOpen(FileNameandPath)
//there is a long delay here for the file to be opened
x is int
j is int
IF IDXLSFile <> -1 THEN
xlsCurrentWorksheet(IDXLSFile,1)
x = xlsNbRow(IDXLSFile)
FOR i=2 TO xlsNbRow(IDXLSFile)
...
end
end

Thanks in advance.



Ericus Steyn