AMAPstudio

User Tools


Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
documentation:exceladdsdoublequotesduringcsvexport [2019/10/25 09:19]
beudez
documentation:exceladdsdoublequotesduringcsvexport [2019/10/25 09:54] (current)
coligny
Line 23: Line 23:
 This extra double quotes addition seems to be done by the 'Save As' feature in Excel. A workaround has been found to get the expected result, based on Copy and Paste, here is an example of how it can be done. This extra double quotes addition seems to be done by the 'Save As' feature in Excel. A workaround has been found to get the expected result, based on Copy and Paste, here is an example of how it can be done.
  
-  - **Open a simple text file editor** (e.g. Textpad, NotePad++, SciTE, gedit...) and create a new empty document +  - **Open a simple text file editor** (e.g. Textpad, NotePad++, SciTE, gedit...) and create a new empty document. 
-  - **In Excel, select the range of cells** to be exported (you may try **Ctrl+A** to select faster the whole document to check if it works) +  - **In Excel, select the range of cells** to be exported (you may try **Ctrl+A** to select faster the whole document to check if it works). 
-  - **Copy the selection** in the system clipboard with **Ctrl+C** +  - **Copy the selection** in the system clipboard with **Ctrl+C**. 
-  - **Paste it in the empty document** in the text editor with **Ctrl+V**+  - **Paste it in the empty document** in the text editor with **Ctrl+V**.
   - **Save** the resulting text file.   - **Save** the resulting text file.
  
-Below is an example of a complex input file with several different sections for the Samsara2 model, which can benefit from this simple technique.+Below is an example of a complex input file with several different sections for the Samsara2 model, which can benefit from this simple ​Copy/​Paste ​technique.
  
 <​code>​ <​code>​
documentation/exceladdsdoublequotesduringcsvexport.1571995166.txt · Last modified: 2019/10/25 09:19 by beudez