| Author |
 Topic  |
|
|
achu6393
India
38 Posts |
 Posted - 06/28/2017 : 1:32:04 PM
|
Hello All,
I am trying to append all the sheets in a workbook into a single sheet. I came across the X-function wAppend can easily perform this task. However, when I used this function the first column (Timestamp) in the first sheet is all set to NULL values, but the other joined sheet data is fine.
I appended the sheets by row and all the columns are of same data types and formats. This might be a silly question, but I am struggling with this.
I have tried wAppend both through script and UI dialog, it gives the same NULL values in both cases.
Thank for your help in advance.
Origin Ver. and Service Release (Select Help-->About Origin): 9.3
Operating System: Win 7
such coding! much wow! |
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 06/28/2017 : 4:56:52 PM
|
Hi achu6393,
I tried wAppend on two worksheets where both contain the Date (or Time) data in the first column to append
them in row-wise, but no problem happened. (The first column in the result was too narrow showing "########",
so I needed to expand the column width.)
So, I'm not sure what happened. Maybe you can send the sample file to technical support as described at:
http://originlab.com/index.aspx?go=Support&pid=752
Regards,
--Hideo Fujii
OriginLab |
Edited by - Hideo Fujii on 06/28/2017 4:57:51 PM |
 |
|
|
achu6393
India
38 Posts |
Posted - 06/29/2017 : 05:37:40 AM
|
Hello Hideo,
I have tired multiple time with different data but i still get '--' for the first sheet first column and theb rest '########' which when expanded shows the value.
I have no idea why! I have contacted the tech support team as you suggested with attached project files. Hope they give a solution.
Thanks! 
such coding! much wow! |
|
|
| |
Topic |
|
|
|
wAppend error for first sheet first column