Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Vilhelm-Ion Praisach
  Where is Vilhelm-Ion Praisach?
 Resita
 Romania
 Vilhelm-Ion Praisach
 To: Vilhelm-Ion Praisach
  Where is Vilhelm-Ion Praisach?
 Resita
 Romania
 Vilhelm-Ion Praisach
 Tags
Subject: RE: copy dbf to xlsx
Thread ID: 414311 Message ID: 416166 # Views: 105 # Ratings: 3
Version: Not Applicable Category: General VFP Topics
Date: Monday, December 22, 2014 10:09:36 PM         
   


> A procedure copytoxlsx.prg for exporting a cursor / table to xlsx (like COPY TO XLS)
> The package includes also a demo testxlsx.prg
>
> Is the raw idea. Must be treated more carefully special characters, like the one with accents.
>
> https://www.foxite.com/uploads/c4227bfd-dd67-4a5a-9a76-52eb84167fa6.rar
>
> Respectfully

Command button class exportxlsx v1.4

https://www.foxite.com/uploads/ecc09568-093b-41e7-be32-612a68b01f71.zip

1) corrections and new  behavior
a) use cfields and cheaders
b) support for more than 702 columns
c) stop the export after the row 1048576 and after the column XFD
d) rows height depend on the font size
e) when memo columns are present, the row height depends on the number of CR (increase the row height according to the number of memo rows)
f) use the chosen font size for memos, when no CR is present (when memo has a single row)
2) new properties
a) SheetName
character (default sheet1)
public
desired sheetname
b) sheetFirstCol
character (default A)
public
start column
c) sheetFirstRow
numeric (default 1)
public
start row
d) lastcol
character (XFD)
public
last valid column (maximum column / sheet)
e) lastrow
numeric (1048576)
public
last valid row (maximum number of rows / sheet)
f) autocolw
logical (default .F.)
public
.T. columns width are evaluated based on font size and the data type (the autosize feature)
3) new methods
a) testprop
protected
on click, test the properties and replace the invalid ones with the default values


Respectfully

ENTIRE THREAD

copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 11/10/2014 12:09:27 AM
RE: copy dbf to xlsx Posted by Martina Jindrov√° @ 11/10/2014 7:57:39 AM
RE: copy dbf to xlsx Posted by Martina Jindrov√° @ 11/10/2014 12:42:44 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 11/10/2014 3:37:44 PM
RE: copy dbf to xlsx Posted by chaim dudi @ 11/10/2014 5:05:40 PM
RE: copy dbf to xlsx Posted by Cesar @ 11/10/2014 5:25:44 PM
RE: copy dbf to xlsx Posted by chaim dudi @ 11/10/2014 5:33:03 PM
RE: copy dbf to xlsx Posted by Cesar @ 11/10/2014 6:11:27 PM
RE: copy dbf to xlsx Posted by Anders Altberg @ 11/10/2014 11:45:54 PM
RE: copy dbf to xlsx Posted by Tore Bleken @ 11/10/2014 5:30:27 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 11/18/2014 4:29:35 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 11/18/2014 8:14:10 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 11/19/2014 9:29:41 AM
RE: copy dbf to xlsx Posted by Cesar @ 11/19/2014 10:51:32 AM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 11/19/2014 11:02:09 AM
RE: copy dbf to xlsx Posted by Cesar @ 11/19/2014 6:36:56 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 11/19/2014 5:34:44 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 11/20/2014 12:27:18 PM
RE: copy dbf to xlsx Posted by Glen Villar @ 12/3/2014 11:51:36 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 11/20/2014 7:59:31 PM
RE: copy dbf to xlsx Posted by mk sharma @ 11/21/2014 6:20:02 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 11/21/2014 7:27:51 PM
RE: copy dbf to xlsx Posted by mk sharma @ 12/27/2014 6:50:24 AM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 11/21/2014 7:23:09 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 11/27/2014 9:39:20 AM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 12/5/2014 8:24:55 PM
RE: copy dbf to xlsx Posted by cata bard @ 12/6/2014 12:38:13 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 12/6/2014 11:10:58 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 12/7/2014 6:46:33 PM
RE: copy dbf to xlsx Posted by khubaib khalid @ 12/8/2014 12:32:45 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 12/8/2014 12:46:38 PM
RE: copy dbf to xlsx Posted by khubaib khalid @ 12/8/2014 1:19:53 PM
RE: copy dbf to xlsx Posted by Naeem Afzal @ 12/25/2014 7:09:54 AM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 12/8/2014 9:56:18 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 12/22/2014 10:09:36 PM
RE: copy dbf to xlsx Posted by Bernard Bout @ 12/24/2014 4:25:13 AM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 12/24/2014 8:10:39 AM
RE: copy dbf to xlsx Posted by Bernard Bout @ 12/26/2014 8:18:05 AM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 12/26/2014 11:18:41 AM
RE: copy dbf to xlsx Posted by Jun Tangunan @ 12/26/2014 11:33:09 AM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 12/26/2014 11:54:48 AM
RE: copy dbf to xlsx Posted by Bernard Bout @ 12/27/2014 5:42:17 AM
RE: copy dbf to xlsx Posted by Cesar @ 2/20/2015 3:08:59 PM
RE: copy dbf to xlsx Posted by Glen Villar @ 2/22/2015 1:12:20 AM
RE: copy dbf to xlsx Posted by tom knauf @ 2/20/2015 2:48:08 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 2/20/2015 4:15:22 PM
RE: copy dbf to xlsx Posted by tom knauf @ 2/20/2015 5:06:16 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 2/20/2015 5:52:46 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 6/13/2015 8:07:49 PM
RE: copy dbf to xlsx Posted by Tony Vignone @ 6/19/2015 4:34:05 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 6/19/2015 5:02:59 PM
RE: copy dbf to xlsx Posted by Tony Vignone @ 6/19/2015 7:27:58 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 12/2/2015 4:25:05 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 12/3/2015 3:56:49 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 12/5/2015 11:12:23 AM
RE: copy dbf to xlsx Posted by Koen Piller @ 12/5/2015 1:14:31 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 12/7/2015 7:59:01 AM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 1/1/2016 8:07:08 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 1/23/2016 12:12:37 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 1/24/2016 11:07:52 AM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 6/2/2016 5:55:48 PM
RE: copy dbf to xlsx Posted by Koen Piller @ 9/19/2016 12:22:46 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 9/19/2016 10:46:26 AM
RE: copy dbf to xlsx Posted by David Kurniawan @ 9/20/2016 1:47:26 AM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 9/20/2016 7:11:25 AM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 11/2/2016 10:15:26 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 11/21/2016 11:55:00 AM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 1/10/2017 12:52:40 PM
RE: copy dbf to xlsx Posted by Koen Piller @ 1/10/2017 5:54:04 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 1/10/2017 8:47:45 PM
RE: copy dbf to xlsx Posted by Koen Piller @ 1/11/2017 4:20:20 PM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 1/11/2017 6:21:39 PM
RE: copy dbf to xlsx Posted by Noel Cris @ 1/11/2017 5:09:01 AM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 1/11/2017 8:46:30 AM
RE: copy dbf to xlsx Posted by Vilhelm-Ion Praisach @ 4/21/2017 9:34:12 AM