+3i want to show filter on the header of column and change size of line and do the words inside cell in the center and each celll has size 50 .i mean rrange the cell and show fiolter that exactly what i need
if it is not possible to apply filter in the output ,at least my input excel has filter on header ,i want to keep the filter as input i mean do no action on it .thanks
Best answer by takashi
I think you can use a template Excel spreadsheet with filters to copy the same style including filters to the destination Excel spreadsheet.
Template example:
Template setting in the Excel writer parameters: set the template Excel file path to the Template File parameter. The template file should contain a worksheet whose name is the same as the destination feature type ("result" in this example).
If you prepare an empty excel file with the formats and filters you need, you can then use a FeatureWriter to write to that empty file, instead of using a Writer to create a new file.
So check out the FeatureWriter and play around with its excel settings and you should be able to get the result you want. Good luck! :-)
+19I think you can use a template Excel spreadsheet with filters to copy the same style including filters to the destination Excel spreadsheet.
Template example:
Template setting in the Excel writer parameters: set the template Excel file path to the Template File parameter. The template file should contain a worksheet whose name is the same as the destination feature type ("result" in this example).
+3I think you can use a template Excel spreadsheet with filters to copy the same style including filters to the destination Excel spreadsheet.
Template example:
Template setting in the Excel writer parameters: set the template Excel file path to the Template File parameter. The template file should contain a worksheet whose name is the same as the destination feature type ("result" in this example).
thanks alot
+3If you prepare an empty excel file with the formats and filters you need, you can then use a FeatureWriter to write to that empty file, instead of using a Writer to create a new file.
So check out the FeatureWriter and play around with its excel settings and you should be able to get the result you want. Good luck! :-)
thanks alot
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
