Ask Your Question
1

How to save opencv data in Excel format?

asked 2012-07-18 16:48:11 -0600

ararr gravatar image

updated 2012-07-19 02:37:51 -0600

Kirill Kornyakov gravatar image

I want to take some information from opencv program and then store it in a file that later can be read by microsoft excel program or even by openoffice and libreOffice.

The information that I need to save is a char variable that takes a value from a function that I wrote, and the other variable is double and represents a property that I take from the VideoCapture class.

In the excel format I want to have a 2 column table that in the first position should be the videoCapture propery(timestamp) and the other column to have the value of the char that I want.

My question is if this can happen though saving my data in a .xml or .yml format that I can do with the use of OpenCV FileStorage class in a way that my file is ready for reading by excel.

Anybody has any idea how do I need to save my data in the xml file ready to read from excel??

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
3

answered 2012-07-18 16:53:19 -0600

AlexanderShishkov gravatar image

I think it is more easy to use .csv format and ordinary formatted output using standart C++ functions from iostream.

http://en.wikipedia.org/wiki/Comma-separated_values

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-07-18 16:48:11 -0600

Seen: 3,410 times

Last updated: Jul 19 '12