| Author |
 Topic  |
|
|
AKazak
Russia
1205 Posts |
|
|
YimingChen
1644 Posts |
 Posted - 07/11/2022 : 09:44:24 AM
|
You can use Data connecter with Import Filter.
1. Create an import filter file.
-> Import Wizard to import the data file.
-> In the File Name Options page, uncheck the boxes to rename worksheet/workbook.
-> In the Save Filters page, check Save filter box. Give it a filter name and save it to User Files Folder.
2. Start a new workbook, select from menu Data-> Connect to File -> Import Filter. Choose the data file, then choose the import filter and import.
James |
 |
|
|
AKazak
Russia
1205 Posts |
Posted - 07/15/2022 : 02:25:52 AM
|
quote:
Originally posted by YimingChen
You can use Data connecter with Import Filter.
1. Create an import filter file.
-> Import Wizard to import the data file.
-> In the File Name Options page, uncheck the boxes to rename worksheet/workbook.
-> In the Save Filters page, check Save filter box. Give it a filter name and save it to User Files Folder.
2. Start a new workbook, select from menu Data-> Connect to File -> Import Filter. Choose the data file, then choose the import filter and import.
James
Dear James,
Got it.
Is there a way to change import filter to the currently connected CSV file?
---
Andrey |
|
|
|
AKazak
Russia
1205 Posts |
Posted - 07/19/2022 : 03:03:04 AM
|
quote:
Originally posted by YimingChen
You can use Data connecter with Import Filter.
1. Create an import filter file.
-> Import Wizard to import the data file.
-> In the File Name Options page, uncheck the boxes to rename worksheet/workbook.
-> In the Save Filters page, check Save filter box. Give it a filter name and save it to User Files Folder.
2. Start a new workbook, select from menu Data-> Connect to File -> Import Filter. Choose the data file, then choose the import filter and import.
James
Dear James,
I followed the step and created the following OIF to connect a CSV file:
https://my.originlab.com/ftp/forum_and_kbase/Images/IJ%20Histogram%20CSV.oif
However, it still renames workbook into partial file name.
Can you reproduce the issue?
Thank you.
---
Andrey |
|
|
|
YimingChen
1644 Posts |
Posted - 07/19/2022 : 09:34:23 AM
|
Yes, I can reproduce the issue. I created the report jira ORG-25526.
James |
|
|
|
snowli
USA
1412 Posts |
Posted - 08/12/2022 : 3:29:56 PM
|
Hi Andrey,
In Origin 2023 beta4 we just announced, we added Other Options button in CSV connector to keep book/sheet name.
There are Sparkline and post script settings there as well.
Also Sparkline and Rename settings can be set as default.
Could you try and give feedback?
Best, Snow
|
|
|
|
AKazak
Russia
1205 Posts |
Posted - 08/13/2022 : 06:52:21 AM
|
quote:
Originally posted by snowli
Hi Andrey,
In Origin 2023 beta4 we just announced, we added Other Options button in CSV connector to keep book/sheet name.
There are Sparkline and post script settings there as well.
Also Sparkline and Rename settings can be set as default.
Could you try and give feedback?
Best, Snow
Dear Snow,
It works as expected in OriginPro 2023 (64-bit) Beta 4 10.0.0.83.
Thank you.
---
Andrey |
Edited by - AKazak on 08/13/2022 06:52:53 AM |
|
|
| |
Topic |
|
2022b SR1: CSV Connector stop renaming wb and wks