Re: Excel + multilanguages

On Tue, 07 Dec 2004 08:20:09 +0100, Jiri Krivanek <jkrivanek1@nbox.cz> wrote: > Hello, > > I am sorry for expressing myself wrong... Naturally, I have read that > response you mentioned... > > THAT IS NOT A SOLUTION OF MY PROBLEM!!!! No need to shout. > > Because that solution only supports a single charset (either 1250 or > 1251, or other) per XLS document. But I need the mix (i.e. the UNICODE - > my data are UNICODE packed by UTF8). Which definitely is supported by > both my MS Excel & my OpenOffice (exported to XLS). Try looking at the Excel Writer source and see if it mentions unicode anywhere. Or ask the author. > > Any other ideas? > > Anyway, thank you for your response & best regards, > > Jiri. > > Justin Patrin napsal(a): > > > > On Tue, 07 Dec 2004 00:19:06 +0100, Jiri Krivanek <jkrivanek1@nbox.cz> wrote: > > > >>Hello, > >> > >>I am trying to generate the excel documents (xls) using the > >>Spreadsheet_Excel_Writer class of PEAR. > >> > >>It works as expected for my local language. > >> > >>But the texts which I need to present via the XLS document are taken > >>from the database in the UNICODE charset, coded using UTF8. Thus from > >>the database, it can be received any mixture of characters (e.g.: latin > >>mixed with cyrilic). > >> > >>My excel supports this without any problem. But in case I pass the UTF8 > >>string to the $worksheet->write() method, I receive unwanted result. > >> > >>Does anyone know how to achieve this? > >> > >>Thank you & best regards, > >> > >>Jiri. > >> > > > > > > This was *just* answered in the list. Today, in fact. Try this: > > > > $xls->_codepage=1250; > > // this codepage are windows codpages > > // i.e. 1250 is for Central Europe > > // 1251 is Cyrillic and so on > > $xls->setVersion(8); > > > -- Justin Patrin