Good Morning,
Need to be able to copy the contents of a cursor to an Excel file, but it needs to be in the xlsx.
Am a newbie to Excel Automation and have read that you can saveas, and it will save in the latest format. Well mine doesn't. oworkbook.version shows 16. (we are running Office 365)
Tried the SweetPotato method but it errors out. Not sure why.
Would someone be kind enough to point me in the right direction, with some possible examples...
TIA, Desmond
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
You are advised to download and install Vilhelm’s excel procedures. They come with examples. Regards Koen
Op ma 16 apr. 2018 om 18:17 schreef Desmond Lloyd desmond.lloyd@gmail.com
Good Morning,
Need to be able to copy the contents of a cursor to an Excel file, but it needs to be in the xlsx.
Am a newbie to Excel Automation and have read that you can saveas, and it will save in the latest format. Well mine doesn't. oworkbook.version shows 16. (we are running Office 365)
Tried the SweetPotato method but it errors out. Not sure why.
Would someone be kind enough to point me in the right direction, with some possible examples...
TIA, Desmond
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
Hi Desmond:
In Vilhelm's Blog there are some Excel import/export functions:
http://praisachion.blogspot.com.es/
Regards.-
2018-04-16 18:17 GMT+02:00 Desmond Lloyd desmond.lloyd@gmail.com:
Good Morning,
Need to be able to copy the contents of a cursor to an Excel file, but it needs to be in the xlsx.
Am a newbie to Excel Automation and have read that you can saveas, and it will save in the latest format. Well mine doesn't. oworkbook.version shows 16. (we are running Office 365)
Tried the SweetPotato method but it errors out. Not sure why.
Would someone be kind enough to point me in the right direction, with some possible examples...
TIA, Desmond
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
On 16/04/2018 17:17, Desmond Lloyd wrote:
Good Morning,
Need to be able to copy the contents of a cursor to an Excel file, but it needs to be in the xlsx.
Am a newbie to Excel Automation and have read that you can saveas, and it will save in the latest format. Well mine doesn't. oworkbook.version shows 16. (we are running Office 365)
Tried the SweetPotato method but it errors out. Not sure why.
Would someone be kind enough to point me in the right direction, with some possible examples...
You can copy the contents of the cursor out to .xls only using the standard COPY TO ... TYPE XL5 Then you can use automation to create an .XLSX file. I'm using office 365 but I am on version 15 so slightly older so you should be able to create an .XLSX file with your version.
#include include\excel.h TRUE=.T. FALSE=.F. oExcel = CREATEOBJECT('excel.application') oExcel.Workbooks.Open(myfile) cOutfile2 = 'myfilev2.xlsx' objexcel.ActiveWorkbook.SaveAs(cOutfile2, xlOpenXMLWorkbook)
In excel.h xlOpenXMLWorkbook is 51
HTH,
Peter
,"This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715
London Office: 101 St. Martin's Lane,London, WC2N 4AZ Tel:0207 299 7960
Look for Vilhelm’s blog he has published several procedures for this with examples Easy Regards Koen
Op ma 16 apr. 2018 om 18:33 schreef Peter Cushing < pcushing@whisperingsmith.com>
On 16/04/2018 17:17, Desmond Lloyd wrote:
Good Morning,
Need to be able to copy the contents of a cursor to an Excel file, but
it
needs to be in the xlsx.
Am a newbie to Excel Automation and have read that you can saveas, and
it
will save in the latest format. Well mine doesn't. oworkbook.version shows 16. (we are running Office 365)
Tried the SweetPotato method but it errors out. Not sure why.
Would someone be kind enough to point me in the right direction, with
some
possible examples...
You can copy the contents of the cursor out to .xls only using the standard COPY TO ... TYPE XL5 Then you can use automation to create an .XLSX file. I'm using office 365 but I am on version 15 so slightly older so you should be able to create an .XLSX file with your version.
#include include\excel.h TRUE=.T. FALSE=.F. oExcel = CREATEOBJECT('excel.application') oExcel.Workbooks.Open(myfile) cOutfile2 = 'myfilev2.xlsx' objexcel.ActiveWorkbook.SaveAs(cOutfile2, xlOpenXMLWorkbook)
In excel.h xlOpenXMLWorkbook is 51
HTH,
Peter
,"This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, https://maps.google.com/?q=h+Ltd+Head+Office:61+Great+Ducie+Street,&entry=gmail&source=g Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715
London Office: 101 St. Martin's Lane,London, WC2N 4AZ Tel:0207 299 7960
[excessive quoting removed by server]
Or learn how to manipulate Excel as a com object and have Excel bring in the data for you into the modern sheet format.
A for loop within a for loop to get rows and columns.
On Mon, Apr 16, 2018 at 11:32 AM, Peter Cushing < pcushing@whisperingsmith.com> wrote:
On 16/04/2018 17:17, Desmond Lloyd wrote:
Good Morning,
Need to be able to copy the contents of a cursor to an Excel file, but it needs to be in the xlsx.
Am a newbie to Excel Automation and have read that you can saveas, and it will save in the latest format. Well mine doesn't. oworkbook.version shows 16. (we are running Office 365)
Tried the SweetPotato method but it errors out. Not sure why.
Would someone be kind enough to point me in the right direction, with some possible examples...
You can copy the contents of the cursor out to .xls only using the
standard COPY TO ... TYPE XL5 Then you can use automation to create an .XLSX file. I'm using office 365 but I am on version 15 so slightly older so you should be able to create an .XLSX file with your version.
#include include\excel.h TRUE=.T. FALSE=.F. oExcel = CREATEOBJECT('excel.application') oExcel.Workbooks.Open(myfile) cOutfile2 = 'myfilev2.xlsx' objexcel.ActiveWorkbook.SaveAs(cOutfile2, xlOpenXMLWorkbook)
In excel.h xlOpenXMLWorkbook is 51
HTH,
Peter
,"This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, https://maps.google.com/?q=h+Ltd+Head+Office:61+Great+Ducie+Street,&entry=gmail&source=g Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office: 101 St. Martin's Lane,London, WC2N 4AZ Tel:0207 299 7960
[excessive quoting removed by server]
The adventage of Vilhelm's method is that he manipulates the XLSX file without Excel (at least for reading, didn't test with writing)
Not needing Excel is really a Plus, because you need an Excel license in each machine that you need to use it, even if you only need an unattended server for automated conversion tasks.
2018-04-16 18:46 GMT+02:00 Stephen Russell srussell705@gmail.com:
Or learn how to manipulate Excel as a com object and have Excel bring in the data for you into the modern sheet format.
A for loop within a for loop to get rows and columns.
On Mon, Apr 16, 2018 at 11:32 AM, Peter Cushing < pcushing@whisperingsmith.com> wrote:
On 16/04/2018 17:17, Desmond Lloyd wrote:
Good Morning,
Need to be able to copy the contents of a cursor to an Excel file, but
it
needs to be in the xlsx.
Am a newbie to Excel Automation and have read that you can saveas, and
it
will save in the latest format. Well mine doesn't. oworkbook.version shows 16. (we are running Office 365)
Tried the SweetPotato method but it errors out. Not sure why.
Would someone be kind enough to point me in the right direction, with some possible examples...
You can copy the contents of the cursor out to .xls only using the
standard COPY TO ... TYPE XL5 Then you can use automation to create an .XLSX file. I'm using office 365 but I am on version 15 so slightly older so you should be able to create an .XLSX file with your version.
#include include\excel.h TRUE=.T. FALSE=.F. oExcel = CREATEOBJECT('excel.application') oExcel.Workbooks.Open(myfile) cOutfile2 = 'myfilev2.xlsx' objexcel.ActiveWorkbook.SaveAs(cOutfile2, xlOpenXMLWorkbook)
In excel.h xlOpenXMLWorkbook is 51
HTH,
Peter
,"This communication is intended for the person or organisation to whom
it
is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, <https://maps.google.com/?q=h+Ltd+Head+Office:61+Great+
Ducie+Street,&entry=gmail&source=g>
Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office: 101 St. Martin's Lane,London, WC2N 4AZ Tel:0207 299 7960
[excessive quoting removed by server]
+1
On 16/04/2018 19:50, Fernando D. Bozzo wrote:
The adventage of Vilhelm's method is that he manipulates the XLSX file without Excel (at least for reading, didn't test with writing)
Not needing Excel is really a Plus, because you need an Excel license in each machine that you need to use it, even if you only need an unattended server for automated conversion tasks.
In busienss consulting, I cannot remember ANYONE that didn't have excel installed. It is a no brainer expecting it in that this is a desktop environment and not a server based web farm.
On Mon, Apr 16, 2018 at 11:50 AM, Fernando D. Bozzo fdbozzo@gmail.com wrote:
The adventage of Vilhelm's method is that he manipulates the XLSX file without Excel (at least for reading, didn't test with writing)
Not needing Excel is really a Plus, because you need an Excel license in each machine that you need to use it, even if you only need an unattended server for automated conversion tasks.
2018-04-16 18:46 GMT+02:00 Stephen Russell srussell705@gmail.com:
Or learn how to manipulate Excel as a com object and have Excel bring in the data for you into the modern sheet format.
A for loop within a for loop to get rows and columns.
On Mon, Apr 16, 2018 at 11:32 AM, Peter Cushing < pcushing@whisperingsmith.com> wrote:
On 16/04/2018 17:17, Desmond Lloyd wrote:
Good Morning,
Need to be able to copy the contents of a cursor to an Excel file,
but
it
needs to be in the xlsx.
Am a newbie to Excel Automation and have read that you can saveas,
and
it
will save in the latest format. Well mine doesn't. oworkbook.version shows 16. (we are running Office 365)
Tried the SweetPotato method but it errors out. Not sure why.
Would someone be kind enough to point me in the right direction, with some possible examples...
You can copy the contents of the cursor out to .xls only using the
standard COPY TO ... TYPE XL5 Then you can use automation to create an .XLSX file. I'm using office 365 but I am on version 15 so slightly older so you should be able to create an .XLSX file with your version.
#include include\excel.h TRUE=.T. FALSE=.F. oExcel = CREATEOBJECT('excel.application') oExcel.Workbooks.Open(myfile) cOutfile2 = 'myfilev2.xlsx' objexcel.ActiveWorkbook.SaveAs(cOutfile2, xlOpenXMLWorkbook)
In excel.h xlOpenXMLWorkbook is 51
HTH,
Peter
,"This communication is intended for the person or organisation to whom
it
is addressed. The contents are confidential and may be protected in
law.
Unauthorised use, copying or disclosure of any of it may be unlawful.
If
you have received this message in error, please notify us immediately
by
telephone or email. www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, <https://maps.google.com/?q=h+Ltd+Head+Office:61+Great+
Ducie+Street,&entry=gmail&source=g>
Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office: 101 St. Martin's Lane,London, WC2N 4AZ Tel:0207 299
7960
[excessive quoting removed by server]
In Business Assurance, with 1000's of licences and CIOs looking for cutting costs down, I can assure you that I know some people that do not have Excel, and of course Excel is not installed on all +300 servers.
2018-04-16 20:33 GMT+02:00 Stephen Russell srussell705@gmail.com:
In busienss consulting, I cannot remember ANYONE that didn't have excel installed. It is a no brainer expecting it in that this is a desktop environment and not a server based web farm.
On Mon, Apr 16, 2018 at 11:50 AM, Fernando D. Bozzo fdbozzo@gmail.com wrote:
The adventage of Vilhelm's method is that he manipulates the XLSX file without Excel (at least for reading, didn't test with writing)
Not needing Excel is really a Plus, because you need an Excel license in each machine that you need to use it, even if you only need an unattended server for automated conversion tasks.
2018-04-16 18:46 GMT+02:00 Stephen Russell srussell705@gmail.com:
Or learn how to manipulate Excel as a com object and have Excel bring
in
the data for you into the modern sheet format.
A for loop within a for loop to get rows and columns.
On Mon, Apr 16, 2018 at 11:32 AM, Peter Cushing < pcushing@whisperingsmith.com> wrote:
On 16/04/2018 17:17, Desmond Lloyd wrote:
Good Morning,
Need to be able to copy the contents of a cursor to an Excel file,
but
it
needs to be in the xlsx.
Am a newbie to Excel Automation and have read that you can saveas,
and
it
will save in the latest format. Well mine doesn't.
oworkbook.version
shows 16. (we are running Office 365)
Tried the SweetPotato method but it errors out. Not sure why.
Would someone be kind enough to point me in the right direction,
with
some possible examples...
You can copy the contents of the cursor out to .xls only using the
standard COPY TO ... TYPE XL5 Then you can use automation to create an .XLSX file. I'm using
office
365 but I am on version 15 so slightly older so you should be able to create an .XLSX file with your version.
#include include\excel.h TRUE=.T. FALSE=.F. oExcel = CREATEOBJECT('excel.application') oExcel.Workbooks.Open(myfile) cOutfile2 = 'myfilev2.xlsx' objexcel.ActiveWorkbook.SaveAs(cOutfile2, xlOpenXMLWorkbook)
In excel.h xlOpenXMLWorkbook is 51
HTH,
Peter
,"This communication is intended for the person or organisation to
whom
it
is addressed. The contents are confidential and may be protected in
law.
Unauthorised use, copying or disclosure of any of it may be unlawful.
If
you have received this message in error, please notify us immediately
by
telephone or email. www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, <https://maps.google.com/?q=h+Ltd+Head+Office:61+Great+
Ducie+Street,&entry=gmail&source=g>
Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office: 101 St. Martin's Lane,London, WC2N 4AZ Tel:0207 299
7960
[excessive quoting removed by server]
This post was to generate XLSX thus they should have excel.
On Mon, Apr 16, 2018 at 2:01 PM, John Weller john@johnweller.co.uk wrote:
I can 😊
John Weller 01380 723235 07976 393631
In business consulting, I cannot remember ANYONE that didn't have excel installed. It is a no brainer expecting it in that this is a desktop environment and not a server based web farm.
[excessive quoting removed by server]
You said that you couldn't remember anyone in a business environment that didn't have Excel. I came across many desks where the user was running a VFP app to produce an output as an Excel file which was then sent to a client who presumably had Excel.
John Weller 01380 723235 07976 393631
This post was to generate XLSX thus they should have excel.
On Mon, Apr 16, 2018 at 2:01 PM, John Weller john@johnweller.co.uk wrote:
I can ??
John Weller 01380 723235 07976 393631
In business consulting, I cannot remember ANYONE that didn't have excel installed. It is a no brainer expecting it in that this is a desktop environment and not a server based web farm.
You could always export in XML format which all newer versions of Excel are capable of reading.
Dave Crozier Software Development Manager Flexipol Packaging Ltd.
--------------------------------------------------------------- This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received.
It is the responsibility of the recipient to ensure that they have adequate virus protection.
Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH
Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk ---------------------------------------------------------------
Terms & Conditions:
Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time
-----Original Message----- From: ProFox profox-bounces@leafe.com On Behalf Of John Weller Sent: 16 April 2018 20:54 To: profox@leafe.com Subject: RE: VFP9 - Save as XLSX
You said that you couldn't remember anyone in a business environment that didn't have Excel. I came across many desks where the user was running a VFP app to produce an output as an Excel file which was then sent to a client who presumably had Excel.
John Weller 01380 723235 07976 393631
This post was to generate XLSX thus they should have excel.
On Mon, Apr 16, 2018 at 2:01 PM, John Weller john@johnweller.co.uk wrote:
I can ??
John Weller 01380 723235 07976 393631
In business consulting, I cannot remember ANYONE that didn't have excel installed. It is a no brainer expecting it in that this is a desktop environment and not a server based web farm.
_______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000c01d3d5bc$ba00f830$2e02e890$@johnw... ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
On Mon, Apr 16, 2018 at 2:54 PM, John Weller john@johnweller.co.uk wrote:
You said that you couldn't remember anyone in a business environment that didn't have Excel. I came across many desks where the user was running a VFP app to produce an output as an Excel file which was then sent to a client who presumably had Excel.
I still stand by my statement that every desktop I have ever developed for from VFP to Web has always had users of spreadsheets that all were excel since the late 90s. Before that it was a lot of Excel and some Quatro Pro as well as 1-2-3.
But I wouldn't bet on them all being legal!!
😉
Dave Crozier Software Development Manager Flexipol Packaging Ltd.
--------------------------------------------------------------- This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received.
It is the responsibility of the recipient to ensure that they have adequate virus protection.
Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH
Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk ---------------------------------------------------------------
Terms & Conditions:
Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time
-----Original Message----- From: ProFox profox-bounces@leafe.com On Behalf Of Stephen Russell Sent: 17 April 2018 15:28 To: ProFox Email List profox@leafe.com Subject: Re: VFP9 - Save as XLSX
On Mon, Apr 16, 2018 at 2:54 PM, John Weller john@johnweller.co.uk wrote:
You said that you couldn't remember anyone in a business environment that didn't have Excel. I came across many desks where the user was running a VFP app to produce an output as an Excel file which was then sent to a client who presumably had Excel.
I still stand by my statement that every desktop I have ever developed for from VFP to Web has always had users of spreadsheets that all were excel since the late 90s. Before that it was a lot of Excel and some Quatro Pro as well as 1-2-3.
-- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN
901.246-0159 cell
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
_______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYJnUW66quxtNW8oB7u0uno=+8L1K=K0... ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
I know nothing about that from years past. My last 4 employers were all legit. Current one gets an audit by our vendor yearly and we just had another one from our new owner, Michael Dell.
On Tue, Apr 17, 2018 at 9:29 AM, Dave Crozier DaveC@flexipol.co.uk wrote:
But I wouldn't bet on them all being legal!!
😉
Dave Crozier Software Development Manager Flexipol Packaging Ltd.
This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received.
It is the responsibility of the recipient to ensure that they have adequate virus protection.
Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH
Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk
Terms & Conditions:
Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time
-----Original Message----- From: ProFox profox-bounces@leafe.com On Behalf Of Stephen Russell Sent: 17 April 2018 15:28 To: ProFox Email List profox@leafe.com Subject: Re: VFP9 - Save as XLSX
On Mon, Apr 16, 2018 at 2:54 PM, John Weller john@johnweller.co.uk wrote:
You said that you couldn't remember anyone in a business environment that didn't have Excel. I came across many desks where the user was running a VFP app to produce an output as an Excel file which was then sent to a client who presumably had Excel.
I still stand by my statement that every desktop I have ever developed for from VFP to Web has always had users of spreadsheets that all were excel since the late 90s. Before that it was a lot of Excel and some Quatro Pro as well as 1-2-3.
-- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN
901.246-0159 cell
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
I am seeing more and more clients using Libre Office or Google Docs, no sign of MS Office anywhere.
Frank.
Frank Cazabon
On 17/04/2018 10:27 AM, Stephen Russell wrote:
On Mon, Apr 16, 2018 at 2:54 PM, John Weller john@johnweller.co.uk wrote:
You said that you couldn't remember anyone in a business environment that didn't have Excel. I came across many desks where the user was running a VFP app to produce an output as an Excel file which was then sent to a client who presumably had Excel.
I still stand by my statement that every desktop I have ever developed for from VFP to Web has always had users of spreadsheets that all were excel since the late 90s. Before that it was a lot of Excel and some Quatro Pro as well as 1-2-3.
On Tue, Apr 17, 2018 at 9:45 AM, Frank Cazabon frank.cazabon@gmail.com wrote:
I am seeing more and more clients using Libre Office or Google Docs, no sign of MS Office anywhere.
I have brought that suggestion up at every company I have worked for and everywhere it was shot down with no thought past retraining hundreds of users how to do the same thing in a new environment. Also the inability to leverage macros from older documents. Last bit was the lack of statistical add-in that excel has for free. Our engineering and quality teams do a lot with that side of the product outside of sum this column.
Different types of clients. Mine tend to be small companies with sometimes less than 10 employees and no legacy of office documents.
On 17 April 2018 11:14:57 GMT-04:00, Stephen Russell srussell705@gmail.com wrote:
On Tue, Apr 17, 2018 at 9:45 AM, Frank Cazabon frank.cazabon@gmail.com wrote:
I am seeing more and more clients using Libre Office or Google Docs,
no
sign of MS Office anywhere.
I have brought that suggestion up at every company I have worked for and everywhere it was shot down with no thought past retraining hundreds of users how to do the same thing in a new environment. Also the inability to leverage macros from older documents. Last bit was the lack of statistical add-in that excel has for free. Our engineering and quality teams do a lot with that side of the product outside of sum this column.
-- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN
901.246-0159 cell
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
I work for a company with 20 plants USA by summer the newest one will be on-line, Another in CA and one UK.
Our month end close for accounting use to take 300 excel documents 7 years ago and now only 15. That is PROGRESS.
Most of the plants plan production on excel as well.
On Tue, Apr 17, 2018 at 10:58 AM, Frank Cazabon frank.cazabon@gmail.com wrote:
Different types of clients. Mine tend to be small companies with sometimes less than 10 employees and no legacy of office documents.
On 17 April 2018 11:14:57 GMT-04:00, Stephen Russell < srussell705@gmail.com> wrote:
On Tue, Apr 17, 2018 at 9:45 AM, Frank Cazabon frank.cazabon@gmail.com wrote:
I am seeing more and more clients using Libre Office or Google Docs,
no
sign of MS Office anywhere.
I have brought that suggestion up at every company I have worked for and everywhere it was shot down with no thought past retraining hundreds of users how to do the same thing in a new environment. Also the inability to leverage macros from older documents. Last bit was the lack of statistical add-in that excel has for free. Our engineering and quality teams do a lot with that side of the product outside of sum this column.
-- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN
901.246-0159 cell
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
On 17 April 2018 at 18:04, Stephen Russell srussell705@gmail.com wrote:
I work for a company with 20 plants USA by summer the newest one will be on-line, Another in CA and one UK.
Our month end close for accounting use to take 300 excel documents 7 years ago and now only 15. That is PROGRESS.
Most of the plants plan production on excel as well.
12 years ago I worked for an large UK/US ticket agency (yes, that one) and everything was Excel sheets. Most of these were generated from FoxBASE (yep).
The FoxBASE apps were positively modern compared to the backend. Ancient VAX systems. Mostly West-End shows but also events at Twickenham rugby stadium (80,000+ seats).
I believe Vilhelm has also import procedures for these procedures.
Op di 17 apr. 2018 om 17:15 schreef Stephen Russell srussell705@gmail.com
On Tue, Apr 17, 2018 at 9:45 AM, Frank Cazabon frank.cazabon@gmail.com wrote:
I am seeing more and more clients using Libre Office or Google Docs, no sign of MS Office anywhere.
I have brought that suggestion up at every company I have worked for and everywhere it was shot down with no thought past retraining hundreds of users how to do the same thing in a new environment. Also the inability to leverage macros from older documents. Last bit was the lack of statistical add-in that excel has for free. Our engineering and quality teams do a lot with that side of the product outside of sum this column.
-- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN
901.246-0159 cell
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
We have hundreds of customers across everything from aerospace to meat packing to game development, and almost without exception they're on MS Office, and latterly Office 365.
If your requirements go beyond very simple documents in any way and/or you have requirements to exchange them with third parties who will almost certainly be using MS Office themselves, or automation requirements then there is only one show in town.
In addition to other suggestions on this thread, there is also a VFPx project that allows you to create XLSX files without Excel being installed. No COM automation involved. One of its core methods creates the output from a cursor or table. It's pretty easy to use and performs well. It also has read from XLSX functionality although I have not really used that other than to try it out.
https://github.com/ggreen86/XLXS-Workbook-Class
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Desmond Lloyd Sent: Monday, April 16, 2018 12:18 PM To: profoxtech@leafe.com Subject: VFP9 - Save as XLSX
Good Morning,
Need to be able to copy the contents of a cursor to an Excel file, but it needs to be in the xlsx.
Am a newbie to Excel Automation and have read that you can saveas, and it will save in the latest format. Well mine doesn't. oworkbook.version shows 16. (we are running Office 365)
Tried the SweetPotato method but it errors out. Not sure why.
Would someone be kind enough to point me in the right direction, with some possible examples...
TIA, Desmond
-
Ajit Abraham -
Alan Bourke -
Dave Crozier -
Desmond Lloyd -
Fernando D. Bozzo -
Frank Cazabon -
John Weller -
Koen Piller -
Paul Hill -
Peter Cushing -
Richard Kaye -
Stephen Russell