You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
107 lines
3.6 KiB
C#
107 lines
3.6 KiB
C#
namespace com.azkoss.excellite
|
|
{
|
|
using System;
|
|
|
|
///<summary>
|
|
///Possible operations that can fire <see cref="com.azkoss.excellite.ExcelFile.LimitNear">ExcelFile.LimitNear</see>
|
|
///and <see cref="com.azkoss.excellite.ExcelFile.LimitReached">ExcelFile.LimitReached</see> events.
|
|
///</summary>
|
|
///<example> Following code demonstrates how to handle <see cref="com.azkoss.excellite.ExcelFile.LimitNear">LimitNear</see>
|
|
///and <see cref="com.azkoss.excellite.ExcelFile.LimitReached">LimitReached</see> events in <b>ExcelLite Free</b>.
|
|
///This sample disables warning worksheet in <see cref="com.azkoss.excellite.ExcelFile.LimitNear">LimitNear</see> event
|
|
///handler and displays console messages in
|
|
///<see cref="com.azkoss.excellite.ExcelFile.LimitReached">LimitReached</see> event handler.
|
|
///<code lang="Visual Basic">
|
|
///Sub Main()
|
|
///Dim ef As ExcelFile = New ExcelFile
|
|
///
|
|
///AddHandler ef.LimitNear, AddressOf ef_LimitNear
|
|
///AddHandler ef.LimitReached, AddressOf ef_LimitReached
|
|
///
|
|
///Dim ws As ExcelWorksheet = ef.Worksheets.Add("Sheet1")
|
|
///
|
|
///Dim i As Integer
|
|
///For i = 0 To 172 - 1 Step i + 1
|
|
///ws.Cells(i, 0).Value = i
|
|
///Next
|
|
///
|
|
///ef.SaveXls("Test.xls")
|
|
///End Sub
|
|
///
|
|
///Private Sub ef_LimitNear(ByVal sender As Object, ByVal e As LimitEventArgs)
|
|
///e.WriteWarningWorksheet = False
|
|
///End Sub
|
|
///
|
|
///Private Sub ef_LimitReached(ByVal sender As Object, ByVal e As LimitEventArgs)
|
|
///Select Case e.Operation
|
|
///Case LimitEventOperation.XlsReading
|
|
///Console.WriteLine("Data truncated while reading XLS file: " + e.FileName)
|
|
///
|
|
///Case LimitEventOperation.CsvReading
|
|
///Console.WriteLine("Data truncated while reading CSV file: " + e.FileName)
|
|
///
|
|
///Case LimitEventOperation.XlsWriting
|
|
///Console.WriteLine("Data truncated while writing XLS file: " + e.FileName)
|
|
///e.WriteWarningWorksheet = False
|
|
///
|
|
///Case LimitEventOperation.CsvWriting
|
|
///Console.WriteLine("Data truncated while writing CSV file: " + e.FileName)
|
|
///
|
|
///End Select
|
|
///End Sub
|
|
///</code>
|
|
///<code lang="C#">
|
|
///static void Main(string[] args)
|
|
///{
|
|
///ExcelFile ef = new ExcelFile();
|
|
///
|
|
///ef.LimitNear += new LimitEventHandler(ef_LimitNear);
|
|
///ef.LimitReached += new LimitEventHandler(ef_LimitReached);
|
|
///
|
|
///ExcelWorksheet ws = ef.Worksheets.Add("Sheet1");
|
|
///
|
|
///for(int i=0; i!=172; i++)
|
|
///ws.Cells[i, 0].Value = i;
|
|
///
|
|
///ef.SaveXls("Test.xls");
|
|
///}
|
|
///
|
|
///private static void ef_LimitNear(object sender, LimitEventArgs e)
|
|
///{
|
|
///e.WriteWarningWorksheet = false;
|
|
///}
|
|
///
|
|
///private static void ef_LimitReached(object sender, LimitEventArgs e)
|
|
///{
|
|
///switch(e.Operation)
|
|
///{
|
|
///case LimitEventOperation.XlsReading:
|
|
///Console.WriteLine("Data truncated while reading XLS file: " + e.FileName);
|
|
///break;
|
|
///
|
|
///case LimitEventOperation.CsvReading:
|
|
///Console.WriteLine("Data truncated while reading CSV file: " + e.FileName);
|
|
///break;
|
|
///
|
|
///case LimitEventOperation.XlsWriting:
|
|
///Console.WriteLine("Data truncated while writing XLS file: " + e.FileName);
|
|
///e.WriteWarningWorksheet = false;
|
|
///break;
|
|
///
|
|
///case LimitEventOperation.CsvWriting:
|
|
///Console.WriteLine("Data truncated while writing CSV file: " + e.FileName);
|
|
///break;
|
|
///}
|
|
///}
|
|
///</code>
|
|
///</example>
|
|
public enum LimitEventOperation
|
|
{
|
|
XlsReading,
|
|
CsvReading,
|
|
XlsWriting,
|
|
CsvWriting
|
|
}
|
|
}
|
|
|