Set file cell *.CSV as merged

Asked

Viewed 306 times

1

Is it possible for a given cell to be merged into a generated *.csv file? I ask because I am generating a *.csv file where the user should only do one Ctrl + C \ Ctrl + v in the content and paste in a standard spreadsheet, however this standard spreadsheet has the cell as merged where will be pasted this content and I can not modify this in the standard spreadsheet so for this reason the need.

import java.nio.charset.StandardCharsets;
import java.util.logging.Logger;
Logger logger= Logger.getLogger("org.bonitasoft");

logger.info(suprimentosDevolvidos.toString())

BufferedWriter strW = new BufferedWriter(new OutputStreamWriter(new FileOutputStream("C:\\TESTE\\suprimentos.csv"), StandardCharsets.ISO_8859_1));

strW.write("QUANTIDADE TOTAL LOTE: "+quantidadeTotalLote.toString()+"\n")
strW.write(suprimentosDevolvidos.toString())
strW.close();
  • you want to format the CSV file in such a way, that when pasting the text of the file in excel ( standard spreadsheet? ) excel merges a cell?

  • I think it is easier to work directly with XLS no? Why is it kind of complicated to work with a file text thus.

  • @Erickweil exactly

  • @Gustavocinque agree with you, but since I already have the code to generate the *.csv file ready I wanted to see if there was a way not to lose all the work

  • In my understanding there is no way even @R.Santos, have to use xls.

  • @Gustavocinque and in xls, you would have some example to show me?

  • 1

    Sorry buddy, I can’t share the codes I use, they’re not even mine, per se. What I can do is that, find something that can make you walk, and that, find something that will solve your doubt.

  • 1

    I hope you can fix it. Really. I’ve been through a lot of trouble with xls, xlsx, etc.

Show 3 more comments
No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.