开发者

MySQL: select into .XLS outfile vertically/targeting specific cells

开发者 https://www.devze.com 2023-02-27 03:19 出处:网络
I\'m trying to output one or two rows at a time from MySQL into an XLS spreadsheet, but Ideally I want it to be vertically, and I want to include the same user defined data alongside each one.

I'm trying to output one or two rows at a time from MySQL into an XLS spreadsheet, but Ideally I want it to be vertically, and I want to include the same user defined data alongside each one.

It should end up looking like this:

Name:  Bobby
Surname: Robson
Favorite food: Chips

Etc. I'd also ideally li开发者_运维问答ke to include a second set of two columns. Is this possible?


There is a Python package called pyExcelerator that can export MySQL data to Excel via Python script. MySQL itself doesn't output in Excel binary format though.


EDIT: Based on the OP's comment, here is a Perl module for writing Excel spreadsheets. Presumably, there exists Perl support for MySQL already ;)

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号