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?
– Erick Weil
I think it is easier to work directly with XLS no? Why is it kind of complicated to work with a file text thus.
– Gustavo Cinque
@Erickweil exactly
– R.Santos
@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
– R.Santos
In my understanding there is no way even @R.Santos, have to use xls.
– Gustavo Cinque
@Gustavocinque and in xls, you would have some example to show me?
– R.Santos
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.
– Gustavo Cinque
I hope you can fix it. Really. I’ve been through a lot of trouble with xls, xlsx, etc.
– Gustavo Cinque