Can someone please help me with the command to hide gridlines when creating an Excel file?
I use the following code :
Code:Dim xlApp As Excel.Application Dim xlWorkBook As Excel.Workbook Dim xlWorkSheet, xlWorkSheet2, xlWorkSheet3 As Excel.Worksheet Dim misValue As Object = System.Reflection.Missing.Value xlApp = New Excel.ApplicationClass xlWorkBook = xlApp.Workbooks.Add(misValue) xlWorkSheet = xlWorkBook.Sheets("sheet1") xlWorkSheet.Name = "BYLAE A" xlWorkSheet2 = xlWorkBook.Sheets.Add xlWorkSheet2.Name = "BYLAE B" xlWorkSheet3 = xlWorkBook.Sheets.Add xlWorkSheet3.Name = "BYLAE C"
And my imports are :
Code:Imports System.ComponentModel Imports System.IO Imports ClosedXML.Excel Imports HtmlAgilityPack Imports Microsoft.Office.Interop Imports MySql.Data.MySqlClient Imports Z.Dapper.Plus
I would have thought xlWorkSheet.displaygridline = false would do the trick, but it is not recognized as a command




Reply With Quote
