T thuryanto New Member Jul 9, 2023 #1 Hello everyone, I am using this Excel library to generate EXCEL files. My question is: How to merge cell Thank you very much for your help
Hello everyone, I am using this Excel library to generate EXCEL files. My question is: How to merge cell Thank you very much for your help
Erel B4X founder Staff member Licensed User Longtime User Jul 10, 2023 #2 Option #1: use an existing sheet with the merged cells and other style you need. Option #2: (untested) B4X: WritableSheet1.As(JavaObject).RunMethod("mergeCells", Array(Col1, Row1, Col2, Row2)) Upvote 0
Option #1: use an existing sheet with the merged cells and other style you need. Option #2: (untested) B4X: WritableSheet1.As(JavaObject).RunMethod("mergeCells", Array(Col1, Row1, Col2, Row2))
T thuryanto New Member Jul 10, 2023 #3 Erel said: Option #1: use an existing sheet with the merged cells and other style you need. Option #2: (untested) B4X: WritableSheet1.As(JavaObject).RunMethod("mergeCells", Array(Col1, Row1, Col2, Row2)) Click to expand... It works, thank you Upvote 0
Erel said: Option #1: use an existing sheet with the merged cells and other style you need. Option #2: (untested) B4X: WritableSheet1.As(JavaObject).RunMethod("mergeCells", Array(Col1, Row1, Col2, Row2)) Click to expand... It works, thank you