You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
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
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.
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.
Activity
Jeltopuz commentedon Sep 17, 2019
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 commentedon Sep 17, 2019
Thank you for your answer, what I want to express is, draw a line on the text, as shown in the picture
xuri commentedon Sep 17, 2019
Thanks for your issue, I will add font strike style support later.
iwalkerr commentedon Sep 17, 2019
Thank you
xuri commentedon Sep 23, 2019
Hi @iwalkerr, I have added font strike style support, you can set like this:
iwalkerr commentedon Sep 23, 2019
Fix qax-os#482, font strike style support
heriipurnama commentedon Sep 14, 2022
How to multiple delete line/row in excel
[-]How to delete line in excel[/-][+]How to add strikethrough format for the cell[/+]xuri commentedon Sep 14, 2022
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 theRemoveCol
function one by one.heriipurnama commentedon Sep 14, 2022
i make looping cant work multiple remove row too.
xuri commentedon Sep 14, 2022
Thanks for your feedback. Which version of Excelize are you using? Can you show us a complete, standalone example program or reproducible demo?
heriipurnama commentedon Sep 15, 2022
i using v1.4.1,
xuri commentedon Sep 15, 2022
Please upgrade to the latest version or using the master branch code if you can, this issue has been fixed.
heriipurnama commentedon Sep 15, 2022
ok i will try
Fix qax-os#482, font strike style support