tag:blogger.com,1999:blog-4295596487699032235.post8450480073388139986..comments2021-05-22T06:20:54.218-07:00Comments on Vilhelm-Ion Praisach: Append from xlsx 3.0Vilhelm-Ion Praisachhttp://www.blogger.com/profile/17594505008976116339noreply@blogger.comBlogger3125tag: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.com