Re: VFP9 - Save as XLSX

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 : > Good Morning, > > Need to be able to copy the contents of a cursor to an Excel file, but it >

Re: VFP9 - Save as XLSX

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 < pcush...@whisperingsmith.com> > On 16/04/2018 17:17, Desmond Lloyd wrote: > > Good Morning, > > > > Need to be able to copy the contents of a

Re: VFP9 - Save as XLSX

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 < pcush...@whisperingsmith.com> wrote: > On 16/04/2018 17:17, Desmond

Re: VFP9 - Save as XLSX

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.

Re: VFP9 - Save as XLSX

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

Re: Modulo 97 of a very large number

How about store orig # as char str - then take chunks starting from left - do Mod of them but results stored as multiple of 10 based upon orig str pos - then I think U can add those sub results together. Just a quick thought off top of my head...-K-

Re: Modulo 97 of a very large number

PGRpdiBkaXI9J2F1dG8nPkRhcm4gLSBJIHJlcGxpZWQgb24gbXkgQ2VsbCAmYW1wOyBkaWRuJ3Qg QyBhbGwgdGhlIHJlcGxpZXMgYWxyZWFkeSB0aGVyZSE8ZGl2IGRpcj0iYXV0byI+PGJyPjwvZGl2 PjxkaXYgZGlyPSJhdXRvIj46LSg8L2Rpdj48ZGl2IGRpcj0iYXV0byI+LUstPC9kaXY+PGRpdiBk

RE: Modulo 97 of a very large number

+1 John Weller 01380 723235 07976 393631 > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > Kurt Wendt > Sent: 16 April 2018 16:51 > To: profoxt...@leafe.com > Subject: Re: Modulo 97 of a very large number > >

Re: VFP9 - Save as XLSX

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 > Good Morning, > > Need to be able to copy the contents of a cursor to an Excel file, but it > needs to be in

Re: VFP9 - Save as XLSX

+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,

RE: Modulo 97 of a very large number

Brilliant Christof Many thanks -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Wollenhaupt, Christof Sent: 16 April 2018 15:36 To: profoxt...@leafe.com Subject: Re: Modulo 97 of a very large number > > I need to calculate N % 97 aka Mod(N,97) for

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

Modulo 97 of a very large number

Sending this message on behalf of Paul Newton who has asked me to relay it to the group as he is having problems sending emails to Profox. He asks the following: Hi all I need to calculate N % 97 aka Mod(N,97) for very large numbers containing 28 digits. Obviously VFP can't handle numbers

RE: Modulo 97 of a very large number

Paul, This may lead somewhere... http://fox.wikis.com/wc.dll?Wiki~VFPFloatingPointDataType Dave Crozier Software Development Manager Flexipol Packaging Ltd. --- This communication and the information it contains is intended for the

Re: Modulo 97 of a very large number

> > I need to calculate N % 97 aka Mod(N,97) for very large numbers containing > 28 digits. Obviously VFP can't handle numbers that large but maybe > somebody can suggest some kind of piece-wise method that would enable me to > calculate what I need? > Sounds like an IBAN checksum calculation.

Re: VFP9 - Save as XLSX

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 wrote: > The adventage of Vilhelm's

Re: VFP9 - Save as XLSX

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 : > In busienss

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 >

Re: VFP9 - Save as XLSX

This post was to generate XLSX thus they should have excel. On Mon, Apr 16, 2018 at 2:01 PM, John Weller 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

RE: VFP9 - Save as XLSX

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

Re: Modulo 97 of a very large number

Ha ha - Very funny John! Its VERY Odd - sometimes my replies on my Cell produce Garbage here! Even my prior reply to this thread - which DID get a reasonably normal posting - still had weird formatting issues. Anyway - my original reply - I felt it might have been a bit of a creative

RE: Modulo 97 of a very large number

Thanks Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 16 April 2018 15:16 To: ProFox Email List Subject: RE: Modulo 97 of a very large number Paul, This may lead somewhere...

RE: Facebook api

My Facebook connection class is finished but Facebook now requires applications to be reviewed by an FB technician and to do that the app must be on the Windows Shop, you must indicate the Url and SID of the App in the windows Shop. My application is not in the store, for this I have to

RE: Facebook api

Excellent, not sure I would have a need but there are many on here who may be very interested. Dave Crozier Software Development Manager Flexipol Packaging Ltd. --- This communication and the information it contains is intended for