How to add strikethrough format for the cell

[iwalkerr]

How to delete line in excel, can god give me some guidance?

[Jeltopuz]

https://xuri.me/excelize/en/sheet.html#SetSheetRow

Remove row
func (f *File) RemoveRow(sheet string, row int) error
RemoveRow provides a function to remove a single row by given worksheet name and Excel row number. For example, remove row 3 in Sheet1:

err := f.RemoveRow("Sheet1", 3)
Use this method with caution, which will affect changes in references such as formulas, charts, and so on. If there is any referenced value of the worksheet, it will cause a file error when you open it. The excelize only partially updates these references currently.

[iwalkerr]

https://xuri.me/excelize/en/sheet.html#SetSheetRow

Remove row
func (f *File) RemoveRow(sheet string, row int) error
RemoveRow provides a function to remove a single row by given worksheet name and Excel row number. For example, remove row 3 in Sheet1:

err := f.RemoveRow("Sheet1", 3)
Use this method with caution, which will affect changes in references such as formulas, charts, and so on. If there is any referenced value of the worksheet, it will cause a file error when you open it. The excelize only partially updates these references currently.

Thank you for your answer, what I want to express is, draw a line on the text, as shown in the picture

[xuri]

Thanks for your issue, I will add font strike style support later.

[iwalkerr]

Thanks for your issue, I will add font strike style support later.

Thank you

[xuri]

Hi @iwalkerr, I have added font strike style support, you can set like this:

f.NewStyle(`{"font":{"strike":true}}`)

[iwalkerr]

Thank you | | walkerr | | 邮箱：walkerr@163.com | On 09/23/2019 21:51, xuri wrote: Hi @iwalkerr, I have added font strike style support, you can set like this: f.NewStyle(`{"font":{"strike":true}}`) — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or mute the thread.

[heriipurnama]

How to multiple delete line/row in excel

[xuri]

The original title of this issue was ambiguous, which was related to the strikethrough style of the cell. I have updated the title for this issue. This library does not support batch removing rows or columns currently, please remove rows or columns by the RemoveRow or the RemoveCol function one by one.

[heriipurnama]

i make looping cant work multiple remove row too.

[xuri]

Thanks for your feedback. Which version of Excelize are you using? Can you show us a complete, standalone example program or reproducible demo?

[heriipurnama]

i using v1.4.1,

[xuri]

Please upgrade to the latest version or using the master branch code if you can, this issue has been fixed.

[heriipurnama]

ok i will try