Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default Converting Excel to CSV

I am using excel to save into csv form but i don't want to include certain
rows(those rows are of no use)
I want to know if there is any way using which i can exclude those rows If
any one know how to do that it will be a great help.

thanks in advance.....
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 268
Default Converting Excel to CSV

If the information you don't require to go to the CSV file are not
contiguous you may like to add a field with an identifier. This would save
(especially if it is a large spreadsheet) trawling through and, possibly
missing a row.

I don't think hiding the row will work.

An easy way would be to -
copy your spreadsheet to a temporary spreadsheet
sort the temporary spreadsheet to bring together those rows identified
as not required
convert to CSV

Depending on how frequently you have to do this routine perhaps a macro may
be more efficient (but I'll leave that to those who know about macros!

Regards.

Bill Ridgeway
Computer Solutions

"HUNTER" wrote in message
...
I am using excel to save into csv form but i don't want to include certain
rows(those rows are of no use)
I want to know if there is any way using which i can exclude those rows If
any one know how to do that it will be a great help.

thanks in advance.....



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Converting Data from pdf into an Excel spreasdsheet torajudo Excel Discussion (Misc queries) 6 April 2nd 06 06:46 PM
How to prevent Excel converting imported fractions into dates Phil A in the UK Excel Discussion (Misc queries) 6 March 28th 06 08:03 AM
Executable for converting excel XML to XLS [email protected] Excel Discussion (Misc queries) 0 March 14th 06 04:01 PM
Stop Excel from converting text labels in CSV files to Values Just Want a Label! Excel Discussion (Misc queries) 1 January 11th 05 04:51 PM


All times are GMT +1. The time now is 07:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"