Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
AppendFromXlsx code and text format in Excel
Message
De
28/01/2020 17:17:51
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01672618
Message ID:
01672820
Vues:
49
J'aime (1)
>>Just an FYI -- I wrote a class to export to XLSX format that has many more capabilities such as multi-sheets, cell merging, cell formatting to include font, border, fills, colors -- see the documentation and release notes. The class is on VFPx -- see link:
>>
>>https://github.com/ggreen86/XLSX-Workbook-Class
>
>>There are specific methods for exporting a table or grid directly to a XLSX that is fast. See the documentation and examples included. I am currently working on enhancements to define the cell formatting when exporting defined in the grid's properties. I have also added features to add images. The updated class should be available in a couple of weeks; most work is done and now testing and fixing issues.

>Hi Greg,
>
>I use that class in the internal utility that imports client retail data into our database. The client submits an Excel with many sheets and then the utility first creates the working cursors, then goes through a lot of business logic in order to properly import the data.
>
>I want to make sure that nothing extra is required to have (e.g. no special drivers, etc.) The class I used does serve this purpose quite well.
>
>Also, you're saying your class is for export into Excel. I need the opposite - import from Excel into cursor.
>
>Thanks.

The class I wrote does not use any external drivers or automation -- it is all native VFP code that reads the XML files that are internal to the XLSX file. The class also has an import feature -- I tested your table example and it correctly imports the values. See the test program included.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform