GrapeCity.Windows.SpreadSheet.UI Namespace > GcSpreadSheet Class > SaveExcel Method : SaveExcel(Stream,ExcelFileFormat,ExcelSaveFlags,String) Method |
'Declaration Public Overloads Sub SaveExcel( _ ByVal stream As System.IO.Stream, _ ByVal format As ExcelFileFormat, _ ByVal saveFlags As ExcelSaveFlags, _ ByVal password As System.String _ )
'Usage Dim instance As GcSpreadSheet Dim stream As System.IO.Stream Dim format As ExcelFileFormat Dim saveFlags As ExcelSaveFlags Dim password As System.String instance.SaveExcel(stream, format, saveFlags, password)
public void SaveExcel( System.IO.Stream stream, ExcelFileFormat format, ExcelSaveFlags saveFlags, System.string password )
SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.Filter = "Excel File (.xlsx)|*.xlsx"; bool? useClick = saveFileDialog.ShowDialog(); if (useClick == true) { var stream = saveFileDialog.OpenFile(); gcSpreadSheet1.SaveExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX); //gcSpreadSheet1.SaveExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.DataOnly); //gcSpreadSheet1.SaveExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.DataOnly, "12Test9"); //gcSpreadSheet1.SaveExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, "12Test9"); stream.Dispose(); }
Dim saveFileDialog = New SaveFileDialog() saveFileDialog.Filter = "Excel File(.xlsx)|*.xlsx" Dim useClick As Boolean = saveFileDialog.ShowDialog() If (useClick = True) Then Dim stream = saveFileDialog.OpenFile() GcSpreadSheet1.SaveExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX) 'GcSpreadSheet1.SaveExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.DataOnly) 'GcSpreadSheet1.SaveExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.DataOnly, "12Test9") 'GcSpreadSheet1.SaveExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, "12Test9") End If
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6