如何防止`ssconvert`在转换前重新计算Excel文件? [英] How to prevent `ssconvert` recalculating Excel file before conversion?
问题描述
我正在尝试转换.xlsx文件 http://www. eia.gov/forecasts/steo/archives/mar14_base.xlsx 转换为.csv,但.xlsx似乎包含链接到我没有的本地文件的公式(该文件的创建者必须忘记粘贴为值而不是公式)
因此,每次使用ssconvert
时,它都会尝试重新计算公式,该公式将失败,因此无法获取数据:
I am trying to convert the .xlsx file http://www.eia.gov/forecasts/steo/archives/mar14_base.xlsx into a .csv, but it seems that the .xlsx contains formulae that link to a local file that I don't have (the creator of the file must have forgotten to paste as values instead of as formula)
so each time I use ssconvert
it tries to recalculate the formula, which fails hence I can't get the data:
ssconvert --export-type=Gnumeric_stf:stf_assistant -O "locale=C
format=automatic separator=, eol=unix sheet='3atab'" "STEO_m.xlsx"
"text.csv"
触发以下消息:(并且.csv中的值丢失)
triggers the following message: (and the values inside the .csv are missing)
(/usr/bin/ssconvert:14771):GLib-GObject-WARNING **: g_object_set_valist:对象类"SheetObjectImage"没有名为"style""7etab"的属性!BM7:
'VLOOKUP($ A7,[1] oracle_allbbb!$ 2:$ 89130,Dates!BM $ 12 + 1,FALSE)'无效的表达式
(/usr/bin/ssconvert:14771): GLib-GObject-WARNING **: g_object_set_valist: object class 'SheetObjectImage' has no property named `style' '7etab'!BM7 :
'VLOOKUP($A7,[1]oracle_allbbb!$2:$89130,Dates!BM$12+1,FALSE)' Invalid expression
我已经看到您的ssconvert
函数中还有一个--recalc参数,但实际上我想做相反的事情!
I have seen that there is also a --recalc argument in your ssconvert
function but actually I want to do the opposite!
ssconvert --recalc = FALSE --export-type = Gnumeric_stf:stf_assistant -O"locale = C format =自动分隔符=,eol = unix sheet ='3atab'""STEO_m.xlsx""text.csv"
ssconvert --recalc=FALSE --export-type=Gnumeric_stf:stf_assistant -O "locale=C format=automatic separator=, eol=unix sheet='3atab'" "STEO_m.xlsx" "text.csv"
您是否可以给我一些建议,以在这里找到解决方案?
Is there any piece of advice you could give me to find a solution here?
推荐答案
显然是一个错误.它是此处固定的.
Apparently it was a bug. It is fixed here.
这篇关于如何防止`ssconvert`在转换前重新计算Excel文件?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!