| T O P I C R E V I E W |
| AKazak |
Posted - 05/27/2022 : 06:18:20 AM
OriginPro 2022b (64-bit) SR1 9.9.5.167
Windows 7 Pro SP1 x64
Greetings!
I noticed that although I have "Start New Sheet" in both 1st File Import Mode and Multi-File (except 1st) Import Mode impMSExcel overwrites the first single sheet in a book.
Has this been done by design?
How do I ask impMSExcel to keep the 1st single sheet untouched and always create new sheets?
Thank you.
---
Andrey |
| 4 L A T E S T R E P L I E S (Newest First) |
| AKazak |
Posted - 05/27/2022 : 12:40:37 PM
quote:
Originally posted by cpyang
Is there a reason that you need to use that old import X-Function? All new improvements in Excel import is in the Excel Connector.
CP
Dear CP,
I use the XF due to its clarity and because it produces static data (I don't require live connection).
Does Excel Connector have more advantages over the XF in this case.
---
Andrey |
| cpyang |
Posted - 05/27/2022 : 11:27:23 AM
Is there a reason that you need to use that old import X-Function? All new improvements in Excel import is in the Excel Connector.
CP
|
| AKazak |
Posted - 05/27/2022 : 11:20:47 AM
quote:
Originally posted by snowli
It is by design to replace blank sheet.
See system varialbe ISE on https://www.originlab.com/doc/LabTalk/ref/sys-var-list?f=dl
Set @ISE=1 to skip blank sheet.
Thanks, Snow
Got it!
Thanks.
---
Andrey |
| snowli |
Posted - 05/27/2022 : 10:09:02 AM
It is by design to replace blank sheet.
See system varialbe ISE on https://www.originlab.com/doc/LabTalk/ref/sys-var-list?f=dl
Set @ISE=1 to skip blank sheet.
Thanks, Snow |
