"hadoopoffice.write.header.write" is only working for default sheet about spark-hadoopoffice-ds HOT 6 CLOSED

that is correct and also the behaviour of the hadoopoffice library. However, it could be a useful enhancement that we can add in the next version. Could you also please share more about your use case?

from spark-hadoopoffice-ds.

According to code, SpreadSheetCellDAO could work for different sheet, so ExcelOutputWriter could write excel file with multiple sheets, with which we can email with single attachment.

Or maybe "hadoopoffice.write.default.sheet.header.write" could be a better name through..

from spark-hadoopoffice-ds.

will be added soon as part of the nedt release. The option will be called hadoopoffice.write.header.writeheaderinallsheets
it will be by default false and can be set to true

from spark-hadoopoffice-ds.

ah wait sorry in know what you mean

from spark-hadoopoffice-ds.

that is in fact already supported: Just use the option "write.spark.defaultsheetname" : this sets the default sheetname to any sheetname you want

from spark-hadoopoffice-ds.

Thanks, great work!

from spark-hadoopoffice-ds.