[Solved] [Calc] Import CSV from row #

Keyboard macros or custom scripts

[Solved] [Calc] Import CSV from row #

Postby Mr.Dandy » Fri Mar 24, 2017 3:16 pm

Hello forum,

I must import data from CSV
How can I set "From row" parameter?
capture.png

I don't find it in https://wiki.openoffice.org/wiki/Docume ... er_Options
Last edited by Mr.Dandy on Fri Mar 24, 2017 3:49 pm, edited 1 time in total.
OpenOffice 4.1.3 - Windows 7
User avatar
Mr.Dandy
 
Posts: 264
Joined: Tue Dec 11, 2012 4:22 pm

Re: [Calc] Import CSV from row #

Postby Villeroy » Fri Mar 24, 2017 3:37 pm

Open the file manually with all required import arguments (almost certainly you want to "Detect special numbers"). Then inspect the document's "Args" property with your favourite object inspector. Args has an element "FilterOptions" which reflects all the options you have used to open the file.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24789
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Calc] Import CSV from row #

Postby Mr.Dandy » Fri Mar 24, 2017 3:49 pm

Wow! Nice tip :)
OpenOffice 4.1.3 - Windows 7
User avatar
Mr.Dandy
 
Posts: 264
Joined: Tue Dec 11, 2012 4:22 pm

Re: [Solved][Calc] Import CSV from row #

Postby karolus » Fri Mar 24, 2017 5:30 pm

Hallo

Jupyter-notebook-screen from another thread after import pandas as pd with pretty signature-hint about allowed keyword-arguments

B_csv.png
hint after <shift>+<tab>
AOO4, Libreoffice - 5.1 … 5.3.2.2 on Linux Mint17
User avatar
karolus
Volunteer
 
Posts: 843
Joined: Sat Jul 02, 2011 9:47 am


Return to OpenOffice Basic, Python, BeanShell, JavaScript

Who is online

Users browsing this forum: No registered users and 7 guests