# Xls\_writer

**URL:** <https://forum.cloverdx.com/t/xls-writer/357>\
**Category:** CloverDX Platform\
**Created:** [July 17, 2008, 12:00am UTC](https://forum.cloverdx.com/t/xls-writer/357 "2008-07-17T00:00:00Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![kimo84](https://avatars.discourse-cdn.com/v4/letter/k/b5ac83/32.png) [@kimo84](https://forum.cloverdx.com/u/kimo84)\
**Post date:** [July 17, 2008, 12:00am UTC](https://forum.cloverdx.com/t/xls-writer/357/1 "2008-07-17T00:00:00Z")

</div>

Bonjour,  
Je travail sur l’outil cloverETL pour génerer un fichier xls a partir d’une table et un autre fichier xls, ces deux source de données vont etre charger dans mon ficher xls cible (xsl\_WRITER) qui est déja existant et qui contient des données.

Mon probleme est lors de l’execution du graphe ETL j’ai un problème d’encodage sur les données qui existe déja ex (é se transforme en ?).

Merci pour votre aide

---

<div class="post-metadata">

**Author:** ![jurban](https://avatars.discourse-cdn.com/v4/letter/j/cc9497/32.png) [@jurban](https://forum.cloverdx.com/u/jurban)\
**Post date:** [July 18, 2008, 7:22am UTC](https://forum.cloverdx.com/t/xls-writer/357/2 "2008-07-18T07:22:03Z")

</div>

Hi,  
I’m sorry, we don’t understand french. Could you please repeat you question in english? Thanks!

Jaro

---

<div class="post-metadata">

**Author:** ![kimo84](https://avatars.discourse-cdn.com/v4/letter/k/b5ac83/32.png) [@kimo84](https://forum.cloverdx.com/u/kimo84)\
**Post date:** [July 18, 2008, 7:47am UTC](https://forum.cloverdx.com/t/xls-writer/357/3 "2008-07-18T07:47:16Z")

</div>

Good morning,

I work with the cloverETL tool to generate a file xls has leave a table and another file xls, this two source of data are going to be make responsible in my do xls target (Xsl\_WRITER) who is already existent and who contains data.

My problem is during the execution of graph ETL I have a problem of encoding on data which already exists ex (’ é ’ is transformed in '? ').

I inform you that I job on an operating system unix and a spreadsheet openoffice.

Thank you for your help.

---

<div class="post-metadata">

**Author:** ![jurban](https://avatars.discourse-cdn.com/v4/letter/j/cc9497/32.png) [@jurban](https://forum.cloverdx.com/u/jurban)\
**Post date:** [July 18, 2008, 7:54am UTC](https://forum.cloverdx.com/t/xls-writer/357/4 "2008-07-18T07:54:21Z")

</div>

Hi,  
you most probably need to set the “charset” parameters of the components to the encoding of your documents (maybe UTF8 ?)

Jaro

---

<div class="post-metadata">

**Author:** ![kimo84](https://avatars.discourse-cdn.com/v4/letter/k/b5ac83/32.png) [@kimo84](https://forum.cloverdx.com/u/kimo84)\
**Post date:** [July 18, 2008, 10:01am UTC](https://forum.cloverdx.com/t/xls-writer/357/5 "2008-07-18T10:01:32Z")

</div>

Greeting,  
I changed the charset but I always have the same problem.

I think that I have a problem in the component XLS\_WRITER. I specified in ownership URL Spins the way of the file xls which contains the names of fields for exemple prénom (name), nationalité (nationality), and I top up data has leave XLS\_READER and a table in XLS\_WRITER (xls file).

After the execution of graph, fields prénom is transformed in ’ pr? nom ’ and nationalité in ’ nationalit? ', problem is in the component XLS\_WRITER, I can not specified the encoding of the file xls.

thank you

---

<div class="post-metadata">

**Author:** ![jurban](https://avatars.discourse-cdn.com/v4/letter/j/cc9497/32.png) [@jurban](https://forum.cloverdx.com/u/jurban)\
**Post date:** [July 18, 2008, 11:27am UTC](https://forum.cloverdx.com/t/xls-writer/357/6 "2008-07-18T11:27:05Z")

</div>

Hi,  
can you enable debug on the edge leading to the XLS writer and look at the data which flows there? Are they correct? If yes then the problem is that you currently cannot specify charset on a XLS Writer, which uses the system charset. And the system charset might not support the characters you want to write.

Jaro

---

<div class="post-metadata">

**Author:** ![kimo84](https://avatars.discourse-cdn.com/v4/letter/k/b5ac83/32.png) [@kimo84](https://forum.cloverdx.com/u/kimo84)\
**Post date:** [July 18, 2008, 12:10pm UTC](https://forum.cloverdx.com/t/xls-writer/357/7 "2008-07-18T12:10:42Z")

</div>

Hi,

I have this problem on data which already exists in the file xls (target file) not in data to charge has leave from the source (file xls and table).

Thanks a lot

---

<div class="post-metadata">

**Author:** ![jurban](https://avatars.discourse-cdn.com/v4/letter/j/cc9497/32.png) [@jurban](https://forum.cloverdx.com/u/jurban)\
**Post date:** [July 18, 2008, 2:09pm UTC](https://forum.cloverdx.com/t/xls-writer/357/8 "2008-07-18T14:09:12Z")

</div>

Hi,  
I’m sorry but I’m not sure what is the question…

Jaro

---

<div class="post-metadata">

**Author:** ![kimo84](https://avatars.discourse-cdn.com/v4/letter/k/b5ac83/32.png) [@kimo84](https://forum.cloverdx.com/u/kimo84)\
**Post date:** [July 18, 2008, 2:42pm UTC](https://forum.cloverdx.com/t/xls-writer/357/9 "2008-07-18T14:42:48Z")

</div>

Hi,

I want to know data why who already exists in the file xls target do not keep source encoding afterwards add it of new data ???.

Thinks.

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [July 21, 2008, 6:49am UTC](https://forum.cloverdx.com/t/xls-writer/357/10 "2008-07-21T06:49:07Z")

</div>

Hi,  
the data were probably written originally with different encoding that you use with clover.
