[Solved] [Calc] Import CSV from row #

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
User avatar
Mr.Dandy
Posts: 427
Joined: Tue Dec 11, 2012 4:22 pm

[Solved] [Calc] Import CSV from row #

Post by Mr.Dandy »

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.12 - Windows 10
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Calc] Import CSV from row #

Post by Villeroy »

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 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Mr.Dandy
Posts: 427
Joined: Tue Dec 11, 2012 4:22 pm

Re: [Calc] Import CSV from row #

Post by Mr.Dandy »

Wow! Nice tip :)
OpenOffice 4.1.12 - Windows 10
User avatar
karolus
Volunteer
Posts: 1159
Joined: Sat Jul 02, 2011 9:47 am

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

Post by karolus »

Hallo

Jupyter-notebook-screen from another thread after import pandas as pd with pretty signature-hint about allowed keyword-arguments
hint after <shift>+<tab>
hint after <shift>+<tab>
AOO4, Libreoffice 6.1 on Rasbian OS (on ARM)
Libreoffice 7.4 on Debian 12 (Bookworm) (on RaspberryPI4)
Libreoffice 7.6 flatpak on Debian 12 (Bookworm) (on RaspberryPI4)
Post Reply