[GH-ISSUE #52] Feature request:add border line functions #44

Closed
opened 2026-05-05 11:28:32 -06:00 by gitea-mirror · 3 comments
Owner

Originally created by @BillSheng on GitHub (Jun 14, 2016).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/52

Originally assigned to: @jmcnamara on GitHub.

I just put your library into my Xcode project and it works just fine. Thank you for your great lib.
But I have to draw border lines of cells for users want this feature as a formal excel document.
Is it possible?

Originally created by @BillSheng on GitHub (Jun 14, 2016). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/52 Originally assigned to: @jmcnamara on GitHub. I just put your library into my Xcode project and it works just fine. Thank you for your great lib. But I have to draw border lines of cells for users want this feature as a formal excel document. Is it possible?
gitea-mirror 2026-05-05 11:28:32 -06:00
  • closed this issue
  • added the
    question
    label
Author
Owner

@jmcnamara commented on GitHub (Jun 14, 2016):

Hi,

You can either use a merge range (like this example) or else create a format for each of the cells in the range with the appropriate border components. For a 3x3 range, or larger, you will need 8 individual formats. It is a bit of work but it is doable.

John

<!-- gh-comment-id:226032188 --> @jmcnamara commented on GitHub (Jun 14, 2016): Hi, You can either use a merge range (like this [example](http://libxlsxwriter.github.io/merge_range_8c-example.html)) or else create a format for each of the cells in the range with the appropriate border components. For a 3x3 range, or larger, you will need 8 individual formats. It is a bit of work but it is doable. John
Author
Owner

@BillSheng commented on GitHub (Jun 15, 2016):

Hi, John,

Thank you for your example!

But I don't want to merge cells to get border line,
Would you please give me a sample to draw lines
for selected range without merge?

Thank you in advance.

SHENG

2016/06/15 7:13$B!"(BJohn McNamara notifications@github.com $B$N%a%C%;!<%8(B:

Hi,

You can either use a merge range (like this example) or else create a format for each of the cells in the range with the appropriate border components. For a 3x3 range, or larger, you will need 8 individual formats. It is a bit of work but it is doable.

John

$B!=(B
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub, or mute the thread.

<!-- gh-comment-id:226066178 --> @BillSheng commented on GitHub (Jun 15, 2016): Hi, John, Thank you for your example! But I don't want to merge cells to get border line, Would you please give me a sample to draw lines for selected range without merge? Thank you in advance. SHENG 2016/06/15 7:13$B!"(BJohn McNamara notifications@github.com $B$N%a%C%;!<%8(B: > Hi, > > You can either use a merge range (like this example) or else create a format for each of the cells in the range with the appropriate border components. For a 3x3 range, or larger, you will need 8 individual formats. It is a bit of work but it is doable. > > John > > $B!=(B > You are receiving this because you authored the thread. > Reply to this email directly, view it on GitHub, or mute the thread.
Author
Owner

@BillSheng commented on GitHub (Jun 15, 2016):

I found the way to draw border for every cell,
Thanks!

Sheng

<!-- gh-comment-id:226067924 --> @BillSheng commented on GitHub (Jun 15, 2016): I found the way to draw border for every cell, Thanks! Sheng
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/libxlsxwriter#44
No description provided.