write_xlsx gem ruby insert复选框在单元格中
我正在使用Ruby 2.5.5和write_xlsx Gem版本：0.85.6用于在Ruby中创建动态Excel表。
我的问题很简单，我想插入复选框是一个单元格。我知道我们还可以使用data_validation下拉下来，我们也可以拥有按钮。但是我需要的是一个简单的复选框，该复选框默认为false，可以将其视为true。
我希望我的问题很清楚，要达到重点。
示例代码：
wb = WriteXLSX.new(filename)
format = Report.format_workbook(wb)
ws = wb.add_worksheet(ws_title)
Report.setup_worksheet(ws)
ws.tab_color = 'yellow'
rt.next_row
ws.merge_range(rt.row, 0, rt.row, 1, "Hours", format[:field_label_bg_orange_bold_center])
ws.write(rt.row, 3, "Booked", format[:bold_right_border])
ws.write(rt.row, 4, "0", format[:bold_center_12_border1])
ws.data_validation(rt.row, 7, {'validate': 'custom', 'value': '=AND(F5=50,G5=60)'})
ws.data_validation(rt.row, 8, {'validate': 'list',
'source': ['TRUE', 'FALSE'],
})
ws.write(rt.row, 8, 'FALSE')
rt.next_row
ws.merge_range(rt.row, 0, rt.row, 1, "Some text goes here", format[:center])
///At this point I want to insert a checkbox
I am using ruby 2.5.5 and write_xlsx gem version: 0.85.6 for creating dynamic Excel sheets in ruby.
My problem is simple, I want to insert a checkbox is a cell. I know we can have drop down using data_validation also we can have button. But what I need is a simple checkbox which is default false and can be checked as value TRUE.
I hope my question is clear and to the point.
example code:
wb = WriteXLSX.new(filename)
format = Report.format_workbook(wb)
ws = wb.add_worksheet(ws_title)
Report.setup_worksheet(ws)
ws.tab_color = 'yellow'
rt.next_row
ws.merge_range(rt.row, 0, rt.row, 1, "Hours", format[:field_label_bg_orange_bold_center])
ws.write(rt.row, 3, "Booked", format[:bold_right_border])
ws.write(rt.row, 4, "0", format[:bold_center_12_border1])
ws.data_validation(rt.row, 7, {'validate': 'custom', 'value': '=AND(F5=50,G5=60)'})
ws.data_validation(rt.row, 8, {'validate': 'list',
'source': ['TRUE', 'FALSE'],
})
ws.write(rt.row, 8, 'FALSE')
rt.next_row
ws.merge_range(rt.row, 0, rt.row, 1, "Some text goes here", format[:center])
///At this point I want to insert a checkbox
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论