in reply to Multiple formats in Excel cell (Spreadsheet::WriteExcel)

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". ;-)
  • Comment on Re: Multiple formats in Excel cell (Spreadsheet::WriteExcel)

Replies are listed 'Best First'.
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

        Thanks but it doesn't seems to work - it print the string as is (&C&"Courier New,Bold Italic"Hello).
        Thanks but it just print the string ('&C&"Courier New,Bold Italic"Hello') when using $worksheet2->write(1,2,'&C&"Courier New,Bold Italic"Hello')...