Skip to content

How to add strikethrough format for the cell #482

@iwalkerr

Description

@iwalkerr

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

删除线

Activity

Jeltopuz

Jeltopuz commented on Sep 17, 2019

@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

iwalkerr commented on Sep 17, 2019

@iwalkerr
Author

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

xuri commented on Sep 17, 2019

@xuri
Member

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

iwalkerr

iwalkerr commented on Sep 17, 2019

@iwalkerr
Author

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

Thank you

xuri

xuri commented on Sep 23, 2019

@xuri
Member

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

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

iwalkerr commented on Sep 23, 2019

@iwalkerr
Author
added a commit that references this issue on Oct 23, 2020
e2fd47f
heriipurnama

heriipurnama commented on Sep 14, 2022

@heriipurnama

How to multiple delete line/row in excel

changed the title [-]How to delete line in excel[/-] [+]How to add strikethrough format for the cell[/+] on Sep 14, 2022
xuri

xuri commented on Sep 14, 2022

@xuri
Member

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

heriipurnama commented on Sep 14, 2022

@heriipurnama

image
i make looping cant work multiple remove row too.

xuri

xuri commented on Sep 14, 2022

@xuri
Member

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

heriipurnama

heriipurnama commented on Sep 15, 2022

@heriipurnama

i using v1.4.1,

xuri

xuri commented on Sep 15, 2022

@xuri
Member

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

heriipurnama

heriipurnama commented on Sep 15, 2022

@heriipurnama

ok i will try

added a commit that references this issue on Mar 14, 2024
75d66a0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

      Development

      No branches or pull requests

        Participants

        @xuri@heriipurnama@iwalkerr@Jeltopuz

        Issue actions

          How to add strikethrough format for the cell · Issue #482 · qax-os/excelize