Multiple formats in Excel cell (Spreadsheet::WriteExcel)

Michaels has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Multiple formats in Excel cell (Spreadsheet::WriteExcel) by afoken (Chancellor) on Apr 05, 2015 at 14:26 UTC
I think this is an Excel problem. As far as I know, Excel defines formats on the cell level, not on the character level. Unless you find a way to make Excel use two formats in one cell, perl can't do that, either. Alexander -- Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)	[reply]
Re^2: Multiple formats in Excel cell (Spreadsheet::WriteExcel) by bitingduck (Deacon) on Apr 05, 2015 at 15:59 UTC
I just checked in Excel 2008 (what I have at home) and can indeed format a string like "this is a string" in a single cell. Not sure how to do it in Spreadsheet::WriteExcel, but it might be possible to save the same file with just a single filled cell in it, where the bold part is the only difference and figure it out	[reply]
Re^3: Multiple formats in Excel cell (Spreadsheet::WriteExcel) by Anonymous Monk on Apr 06, 2015 at 06:54 UTC
http://search.cpan.org/tools/Spreadsheet-WriteExcel-2.40 -> http://search.cpan.org/grep?cpanid=JMCNAMARA&release=Spreadsheet-WriteExcel-2.40&string=bold&i=1&n=1&C=0#examples/colors.pl `2499:You can specify the font of a section of the text by prefixing it + with the control sequence C<&"font,style"> where C<fontname> is a fo +nt name such as "Courier New" or "Times New Roman" and C<style> is on +e of the standard Windows font descriptions: "Regular", "Italic", "Bo +ld" or "Bold Italic": 2502: $worksheet2->set_header('&C&"Courier New,Bold Italic"Hello'); 2760: Bold bold set_bold()` [download] So the docs say its a set_header feature ... I'd try it with cells to see if it works	[reply] [d/l]
Re^4: Multiple formats in Excel cell (Spreadsheet::WriteExcel) by Michaels (Novice) on Apr 07, 2015 at 06:16 UTC
Re^4: Multiple formats in Excel cell (Spreadsheet::WriteExcel) by Michaels (Novice) on Apr 07, 2015 at 07:49 UTC
Re: Multiple formats in Excel cell (Spreadsheet::WriteExcel) by choroba (Cardinal) on Apr 05, 2015 at 09:18 UTC
Crossposted at StackOverflow. It's considered polite to inform about crossposting so people not attending both sites don't waste their time hacking a solution for a problem already solved at the other end of the internet. لսႽ† ᥲᥒ⚪⟊Ⴙᘓᖇ Ꮅᘓᖇ⎱ Ⴙᥲ𝇋ƙᘓᖇ	[reply]
Re^2: Multiple formats in Excel cell (Spreadsheet::WriteExcel) by Michaels (Novice) on Apr 06, 2015 at 05:10 UTC
Sorry - you are right. It's my first post here...	[reply]
Re: Multiple formats in Excel cell (Spreadsheet::WriteExcel) by Anonymous Monk on May 08, 2015 at 10:13 UTC
You can do this with write_rich_string() in Excel::Writer::XLSX, the replacement for Spreadsheet::WriteExcel. `my $bold = $workbook->add_format( bold => 1 ); my $italic = $workbook->add_format( italic => 1 ); $worksheet->write_rich_string( 'A1', 'This is ', $bold, 'bold', ' and this is ', $italic, 'italic' );` [download]	[reply] [d/l]