Gnumeric's ssconvert corrupting file when converting .csv to .xlsx
Clash Royale CLAN TAG#URR8PPP
up vote
0
down vote
favorite
I am using a simple bash script to search for all .csv files in a directory with a certain name and convert them to .xlsx. After that, the script removes the .csv files.
I am using ssconvert for the conversion. Here's the code:
for f in TEST_*.CSV
do
ssconvert "$f" "$f%.CSV.xlsx"
done
rm TEST_*.CSV
The problem is, when I open the resulting xlsx files, Excel displays the following message:
"We found a problem with some content nnnn.xlsx. Do you want us to try and recover as much as we can?"
Since this is going to be used in a fully automated process I cannot depend on this manual step to try to recover the file. Does anyone know why this is happening?
csv file-format excel
edited Nov 21 at 21:49
Jeff Schaller
36.6k1052120
asked Nov 21 at 14:15
Geralt
876
add a comment |
up vote
0
down vote
favorite
I am using a simple bash script to search for all .csv files in a directory with a certain name and convert them to .xlsx. After that, the script removes the .csv files.
I am using ssconvert for the conversion. Here's the code:
for f in TEST_*.CSV
do
ssconvert "$f" "$f%.CSV.xlsx"
done
rm TEST_*.CSV
The problem is, when I open the resulting xlsx files, Excel displays the following message:
"We found a problem with some content nnnn.xlsx. Do you want us to try and recover as much as we can?"
Since this is going to be used in a fully automated process I cannot depend on this manual step to try to recover the file. Does anyone know why this is happening?
csv file-format excel
edited Nov 21 at 21:49
Jeff Schaller
36.6k1052120
asked Nov 21 at 14:15
Geralt
876
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I am using a simple bash script to search for all .csv files in a directory with a certain name and convert them to .xlsx. After that, the script removes the .csv files.
I am using ssconvert for the conversion. Here's the code:
for f in TEST_*.CSV
do
ssconvert "$f" "$f%.CSV.xlsx"
done
rm TEST_*.CSV
The problem is, when I open the resulting xlsx files, Excel displays the following message:
"We found a problem with some content nnnn.xlsx. Do you want us to try and recover as much as we can?"
Since this is going to be used in a fully automated process I cannot depend on this manual step to try to recover the file. Does anyone know why this is happening?
csv file-format excel
edited Nov 21 at 21:49
Jeff Schaller
36.6k1052120
asked Nov 21 at 14:15
Geralt
876
I am using a simple bash script to search for all .csv files in a directory with a certain name and convert them to .xlsx. After that, the script removes the .csv files.
I am using ssconvert for the conversion. Here's the code:
for f in TEST_*.CSV
do
ssconvert "$f" "$f%.CSV.xlsx"
done
rm TEST_*.CSV
The problem is, when I open the resulting xlsx files, Excel displays the following message:
"We found a problem with some content nnnn.xlsx. Do you want us to try and recover as much as we can?"
Since this is going to be used in a fully automated process I cannot depend on this manual step to try to recover the file. Does anyone know why this is happening?
csv file-format excel
csv file-format excel
edited Nov 21 at 21:49
Jeff Schaller
36.6k1052120
asked Nov 21 at 14:15
Geralt
876
edited Nov 21 at 21:49
Jeff Schaller
36.6k1052120
asked Nov 21 at 14:15
Geralt
876
edited Nov 21 at 21:49
Jeff Schaller
36.6k1052120
edited Nov 21 at 21:49
Jeff Schaller
36.6k1052120
edited Nov 21 at 21:49
Jeff Schaller
36.6k1052120
36.6k1052120
asked Nov 21 at 14:15
Geralt
876
asked Nov 21 at 14:15
Geralt
876
asked Nov 21 at 14:15
Geralt
876
876
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f483219%2fgnumerics-ssconvert-corrupting-file-when-converting-csv-to-xlsx%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown