Ask Your Question

How to save only some columns of a spreadsheet? [closed]

asked 2012-06-19 16:41:54 +0200

Jonrysh gravatar image

updated 2012-06-19 16:42:56 +0200

How can I save only some columns of a spreadsheet in csv format?

The situation arises because I need to transform a spreadsheet by modifying a single column according to a formula (which is =MOD(A1-152, 360) ), and then save the spreadsheet with the modified column but not the original one. In more detail, the method is to create a new column, enter the formula into it, and then (hopefully) save as csv. If I delete the original column before saving, the formula becomes an error. If I hide the original column and then save as csv, the original column is saved along with the modified one.

What to do?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-21 00:06:28.092036

1 Answer

Sort by » oldest newest most voted

answered 2013-01-28 07:13:10 +0200

qubit gravatar image

I think that post-processing is your best bet here:

  1. Export all the columns in a CSV file
  2. Remove the extra column

There are a number of different methods of removing that extra column, depending upon what OS you're on and what scripting languages you have available. Here are some good examples in Python:

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2012-06-19 16:41:54 +0200

Seen: 5,075 times

Last updated: Jan 28 '13