tag:blogger.com,1999:blog-4295596487699032235.comments2021-05-22T06:20:54.218-07:00Vilhelm-Ion PraisachVilhelm-Ion Praisachhttp://www.blogger.com/profile/17594505008976116339noreply@blogger.comBlogger24125tag:blogger.com,1999:blog-4295596487699032235.post-60830664551726251712021-05-22T06:20:54.218-07:002021-05-22T06:20:54.218-07:00Not showing Appendfromxls.Prg file Not showing Appendfromxls.Prg file cmtrmstrhttps://www.blogger.com/profile/16693767808722337969noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-75608392342611832282021-01-27T12:23:02.689-08:002021-01-27T12:23:02.689-08:00Vilhelm, I remember your Excel-to-VFP classes seve...Vilhelm, I remember your Excel-to-VFP classes several years ago when I was regularly watching the VFP site foxite.com. <br /><br />Well, finally I had a chance to use them in production and they are nice and solid piece of work. Thank you for your efforts. Hope you in good health. <br /><br />Dan Baker, now in Athens, GA USADan Bakerhttps://www.blogger.com/profile/01437675356720334785noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-31215387951372582222020-08-26T13:29:37.681-07:002020-08-26T13:29:37.681-07:00I just realized part of my problem is my default s...I just realized part of my problem is my default setting is Set Compatible On and your coding requires Set Compatible OffJeff Stonehttps://www.blogger.com/profile/02928966918201254565noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-11958118137293751172020-08-26T09:25:46.913-07:002020-08-26T09:25:46.913-07:00Hi Vilhelm,
I was checking out your ImportFromXlsx...Hi Vilhelm,<br />I was checking out your ImportFromXlsx.prg V4.0 by trying to run test.prg but got runtime errors. If I uncomment<br />#DEFINE archiveWinRar .T.<br />then I get an invalid subscript reference error in gen_table() at:<br /> laDimRef[1,1] = VAL(CHRTRAN(m.lcDimRef1,'ABCDEFGHIJKLMNOPQRSTUVWXYZ',''))<br />because laDimRef is not defined as an array.<br /><br />I also tried running test.prg with WinRAR commented out but the program hung in an endless loop because lnFF = FOPEN(ADDBS(m.lcDir) + m.ofile.name) needs to have ".xml" appended to the end of the file name. After making those changes, the program had an error because workbook.xml was never created.<br /><br />Regards,<br /><br />JeffJeff Stonehttps://www.blogger.com/profile/02928966918201254565noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-35293426833439492672020-05-29T00:52:34.142-07:002020-05-29T00:52:34.142-07:00I am using your importfromxlsx application in wind...I am using your importfromxlsx application in windows 10 pro 64bits and I have infinite loop problem. In some teams it goes and in others it doesn't and I don't know where the problem may come from. With the winrar method it always stays in infinite loop. Regards.Jaketonhttps://www.blogger.com/profile/14276216539692281656noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-56983813755456389712020-05-11T01:01:31.115-07:002020-05-11T01:01:31.115-07:00Thank you for the feedback.
Please give more detai...Thank you for the feedback.<br />Please give more details (like OS, if you launch your app remotely, a.s.o). You can send those details by email.Vilhelm-Ion Praisachhttps://www.blogger.com/profile/17594505008976116339noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-31982263223857925412020-04-19T10:16:38.416-07:002020-04-19T10:16:38.416-07:00Regarding AppendFromXLSX: For me it will not compi...Regarding AppendFromXLSX: For me it will not compile without errors unless i add: EXTERNAL ARRAY laFieldDolittlehttps://www.blogger.com/profile/09851621201439732643noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-11256525243342983362019-03-04T04:20:47.407-08:002019-03-04T04:20:47.407-08:00Thank you for the comment, although is off topicThank you for the comment, although is off topicVilhelm-Ion Praisachhttps://www.blogger.com/profile/17594505008976116339noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-56191093446776157992019-03-04T04:19:54.900-08:002019-03-04T04:19:54.900-08:00Thank you for the comment, although is off topicThank you for the comment, although is off topicVilhelm-Ion Praisachhttps://www.blogger.com/profile/17594505008976116339noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-13064544928942181732019-01-22T03:02:50.922-08:002019-01-22T03:02:50.922-08:00P paragraph tag width text-align justify<a href="https://html-css.happycodings.com/p-paragraph-tag-width-text-align-justify.html" rel="nofollow">P paragraph tag width text-align justify</a><br />carbonhttps://www.blogger.com/profile/16182107774672743687noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-55537792085699381512019-01-22T02:57:49.602-08:002019-01-22T02:57:49.602-08:00label element example codes about css html
Label s...label element example codes about css html<br /><a href="https://html-css.happycodings.com/label-sets-a-text-for-option-element.html" rel="nofollow">Label sets a text for option element</a><br />carbonhttps://www.blogger.com/profile/16182107774672743687noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-89432255058569152382018-06-23T15:18:11.607-07:002018-06-23T15:18:11.607-07:00Man my respects, to all your classes and code you ...Man my respects, to all your classes and code you have done cheers my best rgdsERNESTO PAEZhttps://www.blogger.com/profile/12086922921447526757noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-91067468091877626462018-03-19T19:27:57.972-07:002018-03-19T19:27:57.972-07:00Excellent!Excellent!mk sharmahttps://www.blogger.com/profile/02311771420849625376noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-20231466574757536612018-02-19T10:26:16.876-08:002018-02-19T10:26:16.876-08:00Unfortunately, I found that this program doesn'...Unfortunately, I found that this program doesn't append all information properly from the worksheet. Only few first columns had data and the rest had blanks even though Excel sheet has data. Do you know if there is a way to figure out the issue? Thanks in advance.Naomihttps://www.blogger.com/profile/14349415198731303848noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-40251962942624145062018-02-15T18:22:23.005-08:002018-02-15T18:22:23.005-08:00I was able to fix this problem by introducing a ne...I was able to fix this problem by introducing a new parameter tcExcludeColumn. Now it works for me.Naomihttps://www.blogger.com/profile/14349415198731303848noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-48998523056372397522018-02-15T14:50:26.288-08:002018-02-15T14:50:26.288-08:00Hi,
I'm trying to use AppendFromXlsx program....Hi,<br /><br />I'm trying to use AppendFromXlsx program. I have an Excel file with 15 sheets. The first row in each sheet contains column names (with spaces). The sheet names may also have spaces in them. I am trying the following command wait window nowait 'Processing ' + thisform.aWorkingSheets[m.lnI,1] + ' worksheet'<br /><br /> llReturn = AppendFromXlsx(m.tcExcelFile, thisform.aWorkingSheets[m.lnI,2],,2, thisform.aWorkingSheets[m.lnI,1])<br /><br />and it is failing for me on the GATHER FROM laFieldGat MEMO command. I can see that laFieldGat contains data from the first cell, e.g. laFieldGat = "Western Pa Conservancy". Do you know what I am doing wrong? Can we communicate directly and may be I can send you the excel file? I originally used Craig Boyd's program, but it requires Access DB to be installed. <br />Naomihttps://www.blogger.com/profile/14349415198731303848noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-80969091205825826992016-10-10T04:37:17.040-07:002016-10-10T04:37:17.040-07:00Just added a "How to use it" section to ...Just added a "How to use it" section to answer to your question :)Vilhelm-Ion Praisachhttps://www.blogger.com/profile/17594505008976116339noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-9337485852632151232016-10-09T17:01:13.341-07:002016-10-09T17:01:13.341-07:00
Am fost în căutarea pentru o soluție similară și ...<br />Am fost în căutarea pentru o soluție similară și a ta este excelent. Pur și simplu nu știu cum să-l folosească în propria mea aplicație. Nu am multă experiență în VFP. Ai putea să mă ajute cu un pic mai multe informații despre modul de utilizare a codului te rog? Vă mulțumesc foarte mult în avans.Anonymoushttps://www.blogger.com/profile/07387008339588915772noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-9883647570373986482016-10-09T16:56:12.269-07:002016-10-09T16:56:12.269-07:00Acest comentariu a fost eliminat de autor.Anonymoushttps://www.blogger.com/profile/07387008339588915772noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-82117201762072306842016-09-06T21:54:57.977-07:002016-09-06T21:54:57.977-07:00Excellent work. You saved my time.Excellent work. You saved my time.Zaheerhttps://www.blogger.com/profile/11574958362972130319noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-10554625333157526762016-04-11T04:53:12.143-07:002016-04-11T04:53:12.143-07:00Thank you Koen. Very nice words :-)Thank you Koen. Very nice words :-)Vilhelm-Ion Praisachhttps://www.blogger.com/profile/17594505008976116339noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-80158564767303854492016-03-15T08:46:25.030-07:002016-03-15T08:46:25.030-07:00Vilhelm,
An other one of your goodies!! Excellent ...Vilhelm,<br />An other one of your goodies!! Excellent you have beaten them all.Koenhttps://www.blogger.com/profile/17954141020285818674noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-71385257117869758862016-01-25T04:23:54.300-08:002016-01-25T04:23:54.300-08:00Thank you for the feedback and sorry for the delay...Thank you for the feedback and sorry for the delayed answer.Vilhelm-Ion Praisachhttps://www.blogger.com/profile/17594505008976116339noreply@blogger.comtag:blogger.com,1999:blog-4295596487699032235.post-46804128064713560812016-01-21T13:58:02.848-08:002016-01-21T13:58:02.848-08:00Hi, Vilhelm-Ion.
I think I found a bug in row 576....Hi, Vilhelm-Ion.<br />I think I found a bug in row 576.<br />If the field is empty the follwing bombs:<br />lnTime = (m.ltTime-DATETIME(YEAR(m.ltTime),MONTH(m.ltTime),DAY(m.ltTime),0,0,0))/(86400.0)Dolittlehttps://www.blogger.com/profile/09851621201439732643noreply@blogger.com