copy maps/tables in excel table 3d format

[claudiumxg]

it would be very useful to be able to copy tables in excel format so it can be used for graphs, spreadsheets, easyer analysis of changes in map/table

[Josh Colombo]

I'll second this request. With the current export option, the table does not come over to Excel cleanly.

[Scott]

Hi guys,

Thanks for the feedback, I will add this to the list of requests.

Scott

[johnny_9]

You can copy and paste excel, use text to columns, then transform the row to a matrix. 

http://www.cpearson.com/excel/VectorToMatrix.aspx

then convert the matrix back to a row

http://www.cpearson.com/excel/matrixToVector.aspx

copy to word; replace the tabs (^t) with ,

copy to clipboard, import from clipboard into PC Link

[Daniel Bailey]

I have built up a bunch of Excel tables to deal with a bunch of calculations I find myself doing too often in my head, however obviously not being able to copy data directly between the two is a pain so I threw together a real basic tool to convert between them both.  Nothing fancy at all, but it makes life a LOT easier if you rely on being able to move a lot of table data between the two programs.

Use is simple - select and copy the data you want moved from whatever software, open my program and clip "Convert" and it will tell you what the clipboard data is suitable for being pasted into.   

Cheers,

Dan

[Jeremy Towers]

Awesome Dan. Just what I was looking for!

Cheers, Jeremy

[Daniel Bailey]

No worries, glad it proved helpful