View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
sparks[_3_] sparks[_3_] is offline
external usenet poster
 
Posts: 12
Default does anyone have any idea how to import this spreadsheet?

This is what is weird...I guess its backwards compatibility or
something.

the file is an xlsx but it is wrapping at IV I guess for excel 97 so
we checked and it has about 8000 time values...can the newer excel go
that high?


we end up with a single sheet that looks like this (quick cut and
paste not what we have) over and over until the end of its time cycle.

10/17/2011 4:24:20 4:24:35 4:24:50 4:25:05 4:25:20
BOB1 125 122 120 123 111
BOB2 0 0 0 0 0
BOB3 0 0 0 0 -0.1I


10/17/2011 4:24:20 4:24:35 4:24:50 4:25:05 4:25:20
BOB1 125 122 120 123 111
BOB2 0 0 0 0 0
BOB3 0 0 0 0 -0.1I


10/17/2011 4:24:20 4:24:35 4:24:50 4:25:05 4:25:20
BOB1 125 122 120 123 111
BOB2 0 0 0 0 0
BOB3 0 0 0 0 -0.1I


IF it was a single row of data a quick transpose and we are done.