Native Excel export

[Richard Kreiss]

Top Post:

A much simpler way is to export a CSV file which can them be loaded into into excel without issue (except for formatting the columns)

If you have one of the more recent versions of filePro, you can link it to a preformatted Excel File using ODBC.

There is also an outside tool available which will preformat and output for use with Excel.

In most cases, my clients have selected to export CSV file and import them into an Excel.  From there the apply whatever formatting and formulas they want.


Richard Kreiss
GCC Consulting



> -----Original Message-----
> From: Filepro-list [mailto:filepro-list-
> bounces+rkreiss=verizon.net at lists.celestial.com] On Behalf Of Rick Walsh via
> Filepro-list
> Sent: Monday, June 18, 2018 2:17 PM
> To: filepro-list at lists.celestial.com
> Subject: Native Excel export
> 
> Most of my time these days is trying to get data out of filePro . Most of it is in
> Excel usually use a dif and then format it. Do updated versions of filePro have a
> native Excel export with formatting ? I've been thinking about just writing an
> extra XML export. I'm just want to hear the options are you guys working on.
> We're going into a big development phase right now so I'm just looking for
> options.
> 
> Rick Walsh
> Nexus plastics, Inc.
> Rick at nexusplastics.com
> (201) 615-4882
> 
> On Mon, Jun 18, 2018, 2:00 PM Bill Campbell via Filepro-list < filepro-
> list at lists.celestial.com> wrote:
> 
> > On Mon, Jun 18, 2018, Richard Kreiss via Filepro-list wrote:
> >
> > >I decided to learn Python and the course material recommends pycharm
> > >as
> > the
> > >IDE.
> >
> > >I was wondering what you all may be using?
> >
> > I use vim.
> >
> > >Please keep in mind that I am working in an Windows environment.
> >
> >         https://realpython.com/python-ides-code-editors-guide/
> >
> > Bill
> > --
> > INTERNET:   bill at celestial.com  Bill Campbell; Celestial Software LLC
> > URL: http://www2.celestial.com/ PO Box 820; 6641 E. Mercer Way
> > Mobile:         (206) 947-5591  Mercer Island, WA 98040-0820
> > Fax:            (206) 232-9186  Skype: jwccsllc
> >
> > If you want a picture of the future, imagine a boot stamping on a
> > human face forever.  -- George Orwell
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > Subscribe/Unsubscribe/Subscription Changes
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-
> list/attachments/20180618/d235f535/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 14276 bytes
Desc: not available
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20180618/ad389ed9/attachment.bin>