Welcome, Guest. Please login or register.
Did you miss your activation email?
April 29, 2024, 10:05:08 pm

Login with username, password and session length

Links


FSA logo

Author Topic: Any excel wizards out there?  (Read 972 times)

0 Members and 1 Guest are viewing this topic.

Filo

  • VSC Member
  • Posts: 29961
Any excel wizards out there?
« on October 04, 2016, 06:24:02 pm by Filo »
When I export my spreadsheet as a csv file it only exports the 1st line, what am I doing wrong?



(want to hide these ads? Join the VSC today!)

Muttley

  • VSC Member
  • Posts: 2282
Re: Any excel wizards out there?
« Reply #1 on October 04, 2016, 07:47:44 pm by Muttley »
Why don't you save it as a CSV file rather than exporting it?

Not got work laptop at home so can't check how it works - maybe highlight the entire range before exporting?

Filo

  • VSC Member
  • Posts: 29961
Re: Any excel wizards out there?
« Reply #2 on October 04, 2016, 08:34:09 pm by Filo »
Why don't you save it as a CSV file rather than exporting it?

Not got work laptop at home so can't check how it works - maybe highlight the entire range before exporting?

Thats what I did, but only the first line went

Sammy Chung was King

  • Forum Member
  • Posts: 9676
Re: Any excel wizards out there?
« Reply #3 on October 05, 2016, 01:53:11 am by Sammy Chung was King »
Why does it say i can't see the file i want as it may have been damaged, when i try to view things through adobe reader?.

Filo

  • VSC Member
  • Posts: 29961
Re: Any excel wizards out there?
« Reply #4 on October 05, 2016, 11:49:45 am by Filo »
Sorted, I forgot to put the figure 1 in the reference column on every line, I only put it in the top line so it only exported that

 

TinyPortal © 2005-2012