Martin Mauch

Hey @SubhasisMukherjee, great!! Do you have some Scala experience, or mostly Python?

@SubhasisMukherjee hope you had nice holidays and a good start into the new year 😃 Sorry for not getting back earlier... Do you happen to use spark-excel in some cloud...

This is currently not possible. We're relying on POI to parse the dataAddress and afaik it has to contain something that identifies a cell.

@NogerbekNurzhan it almost looks like the reading stream is closed while it's still reading. Might be caused by spark-excel taking too long to write the data? Can you try forcing...

You can try writing into an existing Excel sheet that already has all the required styles applied. I'm not sure which attributes (e.g. color) will be overwritten when doing that,...

Check the `.mode("append")` part here: https://github.com/crealytics/spark-excel#write-a-dataframe-to-an-excel-file

In principle yes, but I don't have any time to work on this...

Yes, you'd need to adapt the [`toCell method`](https://github.com/crealytics/spark-excel/blob/c613b4b5966a2acc5a3ea7b745848bff4526bd33/src/main/scala/com/crealytics/spark/excel/DataLocator.scala#L118-L131) and use [Spoiwo's styling features](https://github.com/norbert-radyk/spoiwo/blob/c57ced6dcda63d6b2cd093f6c1b7f50f8d41e816/examples/src/main/scala/com/norbitltd/spoiwo/examples/quickguide/SpoiwoExamples.scala) for that. The difficult part would be to figure out, where to store the information of whether...

Hi @jain95Garima, do you have a `spark` instance available at the point where you're `import`ing? The Excel files written by this plugin should be readable by Excel.

Probably related to https://github.com/crealytics/spark-excel/issues/457#issuecomment-984164190 which might be solved by https://github.com/crealytics/spark-excel/pull/597