Is it possible to add borders to an excel range automatically by using datanitro? i.e. something like:
是否可以使用datanitro自动为excel范围添加边框?即:
>>> CellRange("A1:A5").upper_border= True
1 个解决方案
#1
You can't do it directly, but there are two workarounds:
您无法直接执行此操作,但有两种解决方法:
- Write a VBA function to do it and call that from DataNitro: https://datanitro.com/docs/vba.html#calling-vba-from-datanitro
- Copy the formatting from a cell that has it already: https://datanitro.com/docs/cellrange.html?highlight=format#copy_format_from
编写VBA函数来执行此操作并从DataNitro调用它:https://datanitro.com/docs/vba.html#calling-vba-from-datanitro
从已包含格式的单元格中复制格式:https://datanitro.com/docs/cellrange.html?highlight =format #copy_format_from
#1
You can't do it directly, but there are two workarounds:
您无法直接执行此操作,但有两种解决方法:
- Write a VBA function to do it and call that from DataNitro: https://datanitro.com/docs/vba.html#calling-vba-from-datanitro
- Copy the formatting from a cell that has it already: https://datanitro.com/docs/cellrange.html?highlight=format#copy_format_from
编写VBA函数来执行此操作并从DataNitro调用它:https://datanitro.com/docs/vba.html#calling-vba-from-datanitro
从已包含格式的单元格中复制格式:https://datanitro.com/docs/cellrange.html?highlight =format #copy_format_from