OOTP Developments Forums - View Single Post

storm427 · 05-21-2020, 07:31 PM

I cannot figure out how to get data from a report into a spreadsheet, preferable google docs sheets.

I get as far as write report to disc, which opens a browser window with the report and the url shows a local file pathway.

Nothing I try after that results in the data being distibuted into rows and columns in a spreadsheet. I have also tried excel which I only have a license for via my work computer so that is not preferred even if I got it to work.

My goal is to do math with the results of multiple columns, such as select all batters with X as contact, and calculate their average results for H/PA etc.

Can someone explain how to get what I want to happen or point me to a thread on here. Thanks!

05-21-2020, 07:31 PM	#1
storm427 Minors (Single A) Join Date: Feb 2007 Posts: 86 Infractions: 0/1 (2)	Export data to a spreadsheet I cannot figure out how to get data from a report into a spreadsheet, preferable google docs sheets. I get as far as write report to disc, which opens a browser window with the report and the url shows a local file pathway. Nothing I try after that results in the data being distibuted into rows and columns in a spreadsheet. I have also tried excel which I only have a license for via my work computer so that is not preferred even if I got it to work. My goal is to do math with the results of multiple columns, such as select all batters with X as contact, and calculate their average results for H/PA etc. Can someone explain how to get what I want to happen or point me to a thread on here. Thanks!