ExportXlsx 1.8 and CopyToXlsx 1.9.1 4

[vgulielmus]

Improved versions of class (ExportXlsx 1.8) and procedure (CopyToXlsx 1.9.1) that exports data from VFP into Excel 2007+ workbooks
The links from my blog (first link) contains some explanations

CopyToXlsx 2.9.1
direct link
CopyToXlsx 2.9.1

ExportXlsx 1.8
direct link
ExportXlsx 1.8

Respectfully,
Vilhelm-Ion Praisach
Resita, Romania

 

[vgulielmus]

Also updated the importing procedures
- temporary tables are closed
- improved cleanup

Please download the new versions, either from the attached archive, either from the links that points to my blog.
My blog contains some explanations
Excel 2007+ -> DBF
Append from xlsx 2.0
Import from xlsx 2.0
Word 2007+ -> DBF
Append from docx 2.0
IMport from docx 2.0

or directly from the attached link

Respectfully,
Vilhelm-Ion Praisach
Resita, Romania

 

[Dan Olsson]

Vilhelm-Ion.
I think I found a bug in row 576 in CopyToXlsx 3.0
If a datetime field is empty the follwing bombs:
lnTime = (m.ltTime-DATETIME(YEAR(m.ltTime),MONTH(m.ltTime),DAY(m.ltTime),0,0,0))/(86400.0)

 

[vgulielmus]

Thank you. I'll check this weekend.

Respectfully,
Vilhelm-Ion Praisach
Resita, Romania

http://praisachion.blogspot.com/

 

[Dan Olsson]

Bine!

 

[vgulielmus]

Drăguţ răspuns

Respectfully,
Vilhelm-Ion Praisach
Resita, Romania

http://praisachion.blogspot.com/

 

[vgulielmus]

CopyToDocx 2.1
CopyToPptx 2.1
CopyToXlsx 3.1
ExportToDocx 2.1
ExportToPptx 2.1
ExportToXlsx 2.1


1) Bug fixed for Windows older than Windows 7
When the folders are removed (the cleanup procedure). Most probably occurs on Windows Vista systems
Bug 1
2) Bug fixed (only for CopyToXlsx and ExportToXlsx)
Crashes for empty datetime values
Bug 2

Please download from
my blog
or
the attached archive

Thank you, once again, drdolittle


Respectfully,
Vilhelm-Ion Praisach
Resita, Romania

http://praisachion.blogspot.com/

 

[Dan Olsson]

Hi Vilhelm-Ion, thanks for fast fixing.

I have ONE dbf that doesn't work though.
The xlsx is produced without errors but when Excel tries to open it, it says (something like):
Can't read all of the file. Should we try to repair it.
If I click Yes, Excel says it has erased some invalid xml elements, but the resulting file is unusable

Are you willing to test with my dbf and try to see what's going wrong?

 

[vgulielmus]

Hi drdolittle,
Yes, please give me the dbf.

Respectfully,
Vilhelm-Ion Praisach
Resita, Romania

http://praisachion.blogspot.com/

 

[Dan Olsson]

Here it comes. Password is Good Night in romanian

 

[vgulielmus]

Thank you
I hope will give a positive answer tomorrow.

Respectfully,
Vilhelm-Ion Praisach
Resita, Romania

http://praisachion.blogspot.com/

 

[Dan Olsson]

I hope so too. BTW I use Excel 2010...

 

[vgulielmus]

I've found the cause.
The memo field "distintern" contains some binary data for disnr = 2545. You may check that record, but I made a small change.
All I can do is to ignore the characters with ASCII < 32 (remove them from the resulted string, except CHR(9), CHR(10) and CHR(13))

Please download versions 2.2 / 3.2 from my blog
or from attached archive

Respectfully,
Vilhelm-Ion Praisach
Resita, Romania

http://praisachion.blogspot.com/

 

[Dan Olsson]

You are like gold Vilhelm
Mulțumesc foarte mult!

 

[vgulielmus]

My pleasure, and thank you.

Respectfully,
Vilhelm-Ion Praisach
Resita, Romania

http://praisachion.blogspot.com/

 

[Dan Olsson]

It feels like the new enhancements has made dbf2xls slower
I of course COULD go into the code and add some visual aid to let the user see the progress of the conversion, but then I have to do it all over if there is a new version. So I guess my question is: Is it too much to ask that you add some sort of progress bar?

 

[vgulielmus]

I will look a little closer to it.
Also I've got a good suggestion from Koen Piller, that I must try.
It could speed up the entire process.
Just give me several days, please.

Respectfully,
Vilhelm-Ion Praisach
Resita, Romania

http://praisachion.blogspot.com/

 

[vgulielmus]

I hope this week will have some spare time to make some adjustments. I tried yesterday, but I felt exhausted.
I apologize for the delay, but I really have much to work this weeks.

Respectfully,
Vilhelm-Ion Praisach
Resita, Romania

http://praisachion.blogspot.com/

 

[Dan Olsson]

When one waits for something good you never waits too long

 

[Dan Olsson]

Still waiting eagerly for faster conversion and (hopefully) also some sort of progressbar

 

[vgulielmus]

Still without a progressbar.

Bug fixed
Restore the path

The archive contains
CopyToDocx 2.3
Improvements
- Up to 5% faster conversion
- new parameter llopen

CopyToPptx 2.3
Improvements
- Up to 5% faster conversion
- new parameter llopen

CopyToXlsx 3.3
Improvements
- Up to 5% faster conversion
- new parameter lnCodePage
- new parameter llopen

ExportToDocx 2.3
Improvements
- Up to 5% faster conversion
- new property lopen

ExportToPptx 2.3
Improvements
- Up to 5% faster conversion
- new property lopen

ExportToXlsx 2.3
Improvements
- Up to 5% faster conversion
- new property nCodePage
- new property lopen

Download link
Export DBF to MsOffice 2007+ (xlsx, docx, pptx) 2.3
or the attached zip


Respectfully,
Vilhelm-Ion Praisach
Resita, Romania

http://praisachion.blogspot.com/