ROS Resources: Documentation | Support | Discussion Forum | Index | Service Status | ros @ Robotics Stack Exchange

Attention: Answers.ros.org is deprecated as of August the 11th, 2023. Please visit robotics.stackexchange.com to ask a new question. This site will remain online in read-only mode during the transition and into the foreseeable future. Selected questions and answers have been migrated, and redirects have been put in place to direct users to the corresponding questions on Robotics Stack Exchange. Additional details are available here.

0

It is possible to data from topics in xslx file ?

asked 2017-09-06 09:17:05 -0500

Sol
3 ●3 ●5 ●7

I had read subscriber to recieve data and now curious about save that data instead of real time in xslx format (not using bag files). Are there any ways to do it?

edit retag flag offensive close merge delete

Comments

Would a CSV file of some kind be okay? One that could be imported into Excel? If so generating CSV files directly in code is easy in C++ and Python (in Python you could use built-in CSV writers like numpy.savetxt or the CSV module).

jarvisschultz ( 2017-09-06 09:35:11 -0500 )edit

2

There are also some tools for converting bag files to CSV (e.g. rosbag_to_csv) or rostopic echo -p -b <bagname> /topicname > <csvfilename>. If you need XLSX, you could look into something like xlswriter Python

jarvisschultz ( 2017-09-06 09:50:31 -0500 )edit

I've used xlsxwriter to write xlsx files from a bag file and it's very easy to use.

jayess ( 2017-09-06 12:57:23 -0500 )edit

1 Answer

Sort by » oldest newest most voted

1

answered 2017-09-08 10:18:03 -0500

jayess
6155 ●26 ●85 ●92

From the comments on your question by @jarvisschultz and myself, yes it is possible. You can use any library that writes xlsx files such as what @jarvisschultz suggested (XlsxWriter).

I've used XlsxWriter myself and it's quite easy. Just follow the tutorials from the documentation.

You can also use the Working with Excel Sheets Chapter from the book, Automate the Boring Stuff with Python, which uses openpyxl.

edit flag offensive delete link

Question Tools

1 follower

Stats

Asked: 2017-09-06 09:17:05 -0500

Seen: 564 times

Last updated: Sep 08 '17

Related questions

ROS Answers is licensed under Creative Commons Attribution 3.0 Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.

Powered by Askbot version 0.10.2