-----Original Message-----
From: Helge Hafting [mailto:helge.haft...@ntnu.no]
Sent: Wednesday, August 31, 2016 9:52 AM
To: lyx-users@lists.lyx.org
Den 29. aug. 2016 21:26, skrev Jannick:
> Is it possible to specify the tab name in an .xlsx file to be imported
> to lyx using gnumeric's ssconvert.exe?
>
> The conversion command
>
> ssconvert --export-type=Gnumeric_html:latex $$i $$o
>
> picks one of the tabs. I am not sure if ssconvert's -S switch could
> help here, but I would be curious if a specific tab could be chosen.
"man ssconvert" on linux gives some information about options you may want to
investigate:
-S, --export-file-per-sheet
Export a file for each sheet if the exporter only supports one
sheet at a time. The output filename is treated as a template in which sheet
number is substi‐
tuted for %n and/or sheet name is substituted for %s. If there
are not substitutions, a default of ".%s" is added.
This one may give you several files. Further options:
OPTIONS FOR THE PORTABLE DOCUMENT FORMAT (*.pdf) EXPORTER
sheet Name of the workbook sheet to operate on. You can specify
several sheets by repeating this option. If this option is not given the active
sheet (i. e. the
sheet that was active when the file was saved) is used.
This is ignored if the object option is given.
object Name of the sheet object to print. If this option is given any
sheet option is ignored. Only the first object given is exported.
These options are documented specifically for pdf export, (and a few
others) This may or may not work for a latex export. Anyway, LyX can
include PDF into a document too.
Helge Hafting
___________
Thanks, this is helpful.
To have lyx run the compilation, the issue I am struggling with is how to
config the file converter (and/or anything else) to pass on (i) the source
.xlsx file name and (ii) the selected tab name such that for the file converter
1 - $$i is still the original .xlsx file name (like input.xlsx), since lyx
appears to require this input to be able to copy the source file to a temp lyx
folder (with $$i as target file name)
2 - $$o is the .tex file name incl. the table name (probably converted by
ssconvert; like input_FirstTable.tex), since $$o is effectively the temp .tex
file name lyx
I guess the question behind this is how can we pass two independent arguments
to the file converter? Does anyone have any idea - or am I missing something
here?
Thanks,
J.
