Hi,

Can anyone help me about hiding gridlines in excel sheet using VB.NET.

I need to hide gridlines while exporting to excel from VB.NET.

Thanks.

Recommended Answers

Loop through the sheets and do the same for all of them.

Jump to Post

All 3 Replies

Member Avatar

Hi,

Can anyone help me about hiding gridlines in excel sheet using VB.NET.

I need to hide gridlines while exporting to excel from VB.NET.

Thanks.

Assuming you have created a new excel application and Active.WorkSheet
ex.

Dim oExcel as Object
Dim oSheet as Object

oExcel = New Excel.Application
oSheet = oExcel.ActiveSheet

'make the gridlines disapear
oSheet.DisplayGridLines = False

Yes I tried the same. But it removes the gridlines only from Sheet1, it remains viewable in sheet2 & Sheet3.

Loop through the sheets and do the same for all of them.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.