Re: How do you populate an Excel spreadsheet using 4D?

[Arnaud de Montard]

> Le 20 oct. 2016 à 08:52, Andrea Angeli  a écrit :
> 
> Hi Steve,
> I wrote some method that create an xlsx file [...]

If one can work with LibreOffice (free), it contains the feature to save 
documents in a flat XML format (odt -> fodt, ods -> fods, etc.). The document 
is represented as human-readable xml (sic) and not compressed. Easy to use with 
4d tags. 


-- 
Arnaud de Montard 


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: How do you populate an Excel spreadsheet using 4D?

[Andrea Angeli]

Hi Steve,
I wrote some method that create an xlsx file that insert also a picture inside 
that a can share if you want. It Works fine with Number, Open Office and 
LIbreOffice,  but I got some problems between the different versions of EXCEL. 
The problems depend on difference in the use of attributes that should be 
tested in excel. Unfortunately there is not a lot of documentation in how they 
have to use in Excel.
That’s the reason because if I have a complex excel file I still use the 4D 
TAGS. Excel wrote for me the correct file and I don’t need to debug it for all 
version of Excel.
Actually the method can create a simple catalog in an Excel file with text and 
1 picture for each row.

Andrea

> Il giorno 20 ott 2016, alle ore 02:06, Steve Makohin <stevemako...@gmail.com> 
> ha scritto:
> 
> Hi Andrea,
> 
> Thank you for your reply.
> 
> You describe what I've been doing as my "rolled my own" solution. I was 
> wondering if someone else had come to a simpler or more elegant solution.
> 
> -Steve
> 
> 
> 
> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Andrea Angeli
> Sent: Tuesday, October 18, 2016 11:52 AM
> To: 4D iNug Technical
> Subject: Re: How do you populate an Excel spreadsheet using 4D?
> 
> Hallo Steve,
> I used 4D HTML Tag using xlsx file or old excel xml file and it work fine.
> You can build your own graphic in an excel document, save it in xml. Open the 
> file withe a text editor like text wrangler replace the cell values with 4D 
> HTML TAG. You can 4DTEXT and the powerful 4DLOOP if you have table with array 
> and 4DIF for any condition you have. Write your method open your template 
> file fill all your variables and arrays that are in the file then use the 
> command “PROCESS 4D TAGS”, save all in the new document and that’s it!
> I used also a method that write the file directly in xlsx, but it is more 
> complex because you have to know all the xml structure and attribute values.
> 
> Andrea
> 
> 
>> Il giorno 18 ott 2016, alle ore 06:35, Steve Makohin 
>> <stevemako...@gmail.com> ha scritto:
>> 
>> Does anyone know how to populate a formatted Excel spreadsheet using 
>> 4D, and do so under 4D's control? My preferred method is to have 4D replace 
>> "tags"
>> in the spreadsheet with its own values. I'd also prefer if someone 
>> already has the code to do this. I'll be coding in v14.
>> 
>> I've written a sophisticated Excel spreadsheet generator for another 
>> client, but I'm wondering if there's an easier, simple way to go about 
>> this when the spreadsheet is of a known, fixed format.
>> 
>> -Steve
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: How do you populate an Excel spreadsheet using 4D?

[Douglas von Roeder]

Steve:

I wrote code to generate Excel-compatible documents using XML. The code
works fine but the files that it creates get pretty large. I was able to
insert formulas on the fly but couldn't create workbooks.

A couple of years ago, I looked around for a way to create more robust
documents and started using the plugin from Pluggers. The plugin gives me a
tremendous amount of control over the output and, like all of the other
products from Pluggers, it was money well spent.



--
Douglas von Roeder
949-336-2902

On Wed, Oct 19, 2016 at 5:06 PM, Steve Makohin <stevemako...@gmail.com>
wrote:

> Hi Andrea,
>
> Thank you for your reply.
>
> You describe what I've been doing as my "rolled my own" solution. I was
> wondering if someone else had come to a simpler or more elegant solution.
>
> -Steve
>
>
>
> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Andrea
> Angeli
> Sent: Tuesday, October 18, 2016 11:52 AM
> To: 4D iNug Technical
> Subject: Re: How do you populate an Excel spreadsheet using 4D?
>
> Hallo Steve,
> I used 4D HTML Tag using xlsx file or old excel xml file and it work fine.
> You can build your own graphic in an excel document, save it in xml. Open
> the file withe a text editor like text wrangler replace the cell values
> with 4D HTML TAG. You can 4DTEXT and the powerful 4DLOOP if you have table
> with array and 4DIF for any condition you have. Write your method open your
> template file fill all your variables and arrays that are in the file then
> use the command “PROCESS 4D TAGS”, save all in the new document and that’s
> it!
> I used also a method that write the file directly in xlsx, but it is more
> complex because you have to know all the xml structure and attribute values.
>
> Andrea
>
>
> > Il giorno 18 ott 2016, alle ore 06:35, Steve Makohin <
> stevemako...@gmail.com> ha scritto:
> >
> > Does anyone know how to populate a formatted Excel spreadsheet using
> > 4D, and do so under 4D's control? My preferred method is to have 4D
> replace "tags"
> > in the spreadsheet with its own values. I'd also prefer if someone
> > already has the code to do this. I'll be coding in v14.
> >
> > I've written a sophisticated Excel spreadsheet generator for another
> > client, but I'm wondering if there's an easier, simple way to go about
> > this when the spreadsheet is of a known, fixed format.
> >
> > -Steve
>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
>
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: How do you populate an Excel spreadsheet using 4D?

[Steve Makohin]

Hi Andrea,

Thank you for your reply.

You describe what I've been doing as my "rolled my own" solution. I was 
wondering if someone else had come to a simpler or more elegant solution.

-Steve



-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Andrea Angeli
Sent: Tuesday, October 18, 2016 11:52 AM
To: 4D iNug Technical
Subject: Re: How do you populate an Excel spreadsheet using 4D?

Hallo Steve,
I used 4D HTML Tag using xlsx file or old excel xml file and it work fine.
You can build your own graphic in an excel document, save it in xml. Open the 
file withe a text editor like text wrangler replace the cell values with 4D 
HTML TAG. You can 4DTEXT and the powerful 4DLOOP if you have table with array 
and 4DIF for any condition you have. Write your method open your template file 
fill all your variables and arrays that are in the file then use the command 
“PROCESS 4D TAGS”, save all in the new document and that’s it!
I used also a method that write the file directly in xlsx, but it is more 
complex because you have to know all the xml structure and attribute values.

Andrea


> Il giorno 18 ott 2016, alle ore 06:35, Steve Makohin <stevemako...@gmail.com> 
> ha scritto:
> 
> Does anyone know how to populate a formatted Excel spreadsheet using 
> 4D, and do so under 4D's control? My preferred method is to have 4D replace 
> "tags"
> in the spreadsheet with its own values. I'd also prefer if someone 
> already has the code to do this. I'll be coding in v14.
> 
> I've written a sophisticated Excel spreadsheet generator for another 
> client, but I'm wondering if there's an easier, simple way to go about 
> this when the spreadsheet is of a known, fixed format.
> 
> -Steve


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: How do you populate an Excel spreadsheet using 4D?

[Charlie Vass]

See Tech Note: Exporting the Smart Way — Using Smart Templates 
.

Charlie Vass
4D TS

> On Oct 18, 2016, at 12:35 AM, Steve Makohin  wrote:
> 
> Does anyone know how to populate a formatted Excel spreadsheet using 4D, and
> do so under 4D's control? My preferred method is to have 4D replace "tags"
> in the spreadsheet with its own values. I'd also prefer if someone already
> has the code to do this. I'll be coding in v14.
> 
> I've written a sophisticated Excel spreadsheet generator for another client,
> but I'm wondering if there's an easier, simple way to go about this when the
> spreadsheet is of a known, fixed format.
> 
> -Steve
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: How do you populate an Excel spreadsheet using 4D?

[bob . miller]

RE> How do you populate an Excel spreadsheet using 4D?

I'm using Plugger's excellent Excel plugin; it is a bit pricey, but very 
full featured and solid as a rock.

http://www.pluggers.nl/product/xl-plugin/

Miyako also published a free plugin that does some Excel functions; I 
evaluated that, but it didn't go far enough for what I was looking for - 
multiple sheets, styles applied, etc.


Bob Miller 
Chomerics, a division of Parker Hannifin Corporation



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

How do you populate an Excel spreadsheet using 4D?

[Steve Makohin]

Does anyone know how to populate a formatted Excel spreadsheet using 4D, and
do so under 4D's control? My preferred method is to have 4D replace "tags"
in the spreadsheet with its own values. I'd also prefer if someone already
has the code to do this. I'll be coding in v14.

I've written a sophisticated Excel spreadsheet generator for another client,
but I'm wondering if there's an easier, simple way to go about this when the
spreadsheet is of a known, fixed format.

-Steve

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**