Scott,
The following line causes the Windows native dialogs to appear.
loShell.NameSpace(tcZipFile).MoveHere(loFile, FOF_SILENT)
This is in the "AddFilesToZip" method.
Obviously, loShell is created as below
loShell = CREATEOBJECT("shell.application")
Dear all,
I am writing contents of a DBF file to a XLSX file using the VFPxWorkbookXLSX library.
When the "SaveTableToWorkbookEx" method is running, it shows the native Windows' file copy dialogs.
Is there a way to disable these?
Dear all,
I think that particular error comes up when we don't have a ENDTRY after the CATCH.
TRY
=MYPRG("PARAM1") && This PRG has TRY/CATCH and it works fine.
CATCH
Now, when MYPRG exits, it gives the mismatch error.
So, let me check with my client, if his calling program has a wrong...
Hi all,
My client getting TRY/CATCH mismatch error in one program. Its a program where we convert a DBF to XLSX using the "VfpXworkbookXLSX" library. When I run at my end I don't come across that in spite of trying with various scenarios. Too, apparently I am not able to find anything wrong...
Hi mJindrova,
Yes, that's the one.
In fact, I want to read from XLSX and break into multiple files for subsequent import into one web application.
So, I am trying to read a set of rows (from source) and writing to a new XLSX.
I am writing cell by cell as I couldn't find a way to copy a range...
Hi Chriss,
Yes, because of the nature of XLSX format, may be it takes time. The file is only 58kb.
Maybe, it has may inner files and uncompressing time may also be a reason.
I will do an analysis once my primary program code is finished.
Rajesh
Dear friends,
I have been using VFPxWorkbookXLSX for working with XLSX files. But so far, they were all considerably small files.
Now, when I try to open a file with 16800 records and 38 columns, it appears it takes more than half a minute to open it.
Is this usual?
Rajesh
Hello kyletreyfield,
If you have not VFP installation in your pc and you keep your VFP runtimes in your application folder itself,
please check if you have all necessary files in place. A typical list will be as follows:
All files above may not be essential though.
Even if you think, you...
Hi friends,
A simple query. I have been using VFPxWorkbookXLSX to work with .XLSX file... pretty good...!
However, when I try to open a .XLS file, both 'OpenXlsxWorkbook' and 'OpenXlsxWorkbookSheet' returns 0, i.e., it failed!
E.g:
oSource = NEWOBJECT("VFPxWorkbookXLSX"...
Hello SitesMasstec,
I don't think, trying to relate the tables through the internal Record Number is a good idea because there are chances that at times, the same record number in the two table may not correspond to same logical record we think of. This might happen because of even unforeseen...
Hi Chriss,
Thank you for the reply. I do agree and usually I go the proper way for transferring a software (even our own ones!) and supporting packages. In this case, I am not sure if there was a setup routine. Let me check if I can find it.
Thanks
Rajesh
Rajesh
Hi Team!
We are using the below DLL for Pivot data generation. It was working fine. However, when we changed to a new computer, it stopped working (obviously, must be because the DLL need to be registered).
DevExpress.XtraPivotGrid.v7.1.dll
DevExpress.XtraPivotGrid.v7.1.Core.dll (we have...
Dear all,
I tried changing the memo fields contents with '' but even though it did not throw any error, still I was getting the same error when tried to open memo field.
Finally, in current table, I removed all the memo fields and re-added them. Then I updated all the memo fields from my last...
Griff,
The size of the FPT (the file after I fixed it with utility) is not zero but considerably good. But, when I copied the dbf/fpt to another temporary database in another folder, the size came as 1kb. The Memo field is editable there, but the values in all records are blank (yeah! because...
Dear all,
We have a table with 4 Memo fields. It was corrupted somehow and we repaired it using a utility called 'Advanced DBF Repair' (my office has this since long). After repair, accessing the table appears to be completely okay.
But however the Memo fields are not accessible. When I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.