1: XlsDocumentBuilder builder = new XlsDocumentBuilder();
2: //create a workbook
3: IXlsWorkbook book = builder.Create(1);
4:
5: //Add worksheet
6: IXlsWorksheet sheet = book.Worksheets[0];
7:
8: ////header
9: int row = 2;
10: sheet.Range[row, 2].Value = "Data type";
11: sheet.Range[row, 3].Value = "Min value";
12: sheet.Range[row, 4].Value = "Max value";
13: sheet.Range[row, 2, row, 4].CellStyle.Font.Bold = true;
14:
15: ////Numberic values
16: row += 2;
17: IXlsRange title = sheet.Range[row, 2, row, 4];
18: title.Merge();
19: title.Value = "Numeric values";
20: title.CellStyle.Font.Italic = true;
21:
22: ////byte
23: row++;
24: sheet.Range[row, 2].Value2 = "System.Byte (byte)";
25: sheet.Range[row, 3].Value2 = System.Byte.MinValue;
26: sheet.Range[row, 4].Value2 = System.Byte.MaxValue;
27:
28: ////sbyte
29: row++;
30: sheet.Range[row, 2].Value2 = "System.SByte";
31: sheet.Range[row, 3].Value2= System.SByte.MinValue;
32: sheet.Range[row, 4].Value2 = System.SByte.MaxValue;
33:
34: ////Int16
35: row++;
36: sheet.Range[row, 2].Value2 = "System.Int16 (short)";
37: sheet.Range[row, 3].Value2 = System.Int16.MinValue;
38: sheet.Range[row, 4].Value2 = System.Int16.MaxValue;
39:
40: ////UInt16
41: row++;
42: sheet.Range[row, 2].Value2 = "System.UInt16 (ushort)";
43: sheet.Range[row, 3].Value2 = System.UInt16.MinValue;
44: sheet.Range[row, 4].Value2 = System.UInt16.MaxValue;
45:
46: ////Int32
47: row++;
48: sheet.Range[row, 2].Value2 = "System.Int32 (int)";
49: sheet.Range[row, 3].Value2 = System.Int32.MinValue;
50: sheet.Range[row, 4].Value2 = System.Int32.MaxValue;
51:
52: ////UInt32
53: row++;
54: sheet.Range[row, 2].Value2 = "System.UInt32 (uint)";
55: sheet.Range[row, 3].Value2 = System.UInt32.MinValue;
56: sheet.Range[row, 4].Value2 = System.UInt32.MaxValue;
57:
58:
59: ////Int64
60: row++;
61: sheet.Range[row, 2].Value2 = "System.Int64 (long)";
62: sheet.Range[row, 3].Value2 = System.Int64.MinValue;
63: sheet.Range[row, 4].Value2 = System.Int64.MaxValue;
64:
65: ////UInt64
66: row++;
67: sheet.Range[row, 2].Value2 = "System.UInt64 (ulong)";
68: sheet.Range[row, 3].Value2 = System.UInt64.MinValue;
69: sheet.Range[row, 4].Value2 = System.UInt64.MaxValue;
70:
71: ////Single
72: row++;
73: sheet.Range[row, 2].Value2 = "System.Single (float)";
74: sheet.Range[row, 3].Value2 = System.Single.MinValue;
75: sheet.Range[row, 4].Value2 = System.Single.MaxValue;
76:
77: ////Double
78: row++;
79: sheet.Range[row, 2].Value2 = "System.Double (double)";
80: sheet.Range[row, 3].Value2 = System.Double.MinValue;
81: sheet.Range[row, 4].Value2 = System.Double.MaxValue;
82:
83: ////Decimal
84: row++;
85: sheet.Range[row, 2].Value2 = "System.Decimal (decimal)";
86: sheet.Range[row, 3].Value2 = System.Decimal.MinValue;
87: sheet.Range[row, 4].Value2 = System.Decimal.MaxValue;
88:
89: ////Empty values
90: row += 2;
91: title = sheet.Range[row, 2, row, 4];
92: title.Merge();
93: title.Value2 = "Empty values";
94: title.CellStyle.Font.Italic = true;
95:
96: ////null
97: row++;
98: sheet.Range[row, 2].Value2 = "null";
99: sheet.Range[row, 3].Value2 = null;
100: sheet.Range[row, 4].Value2 = null;
101:
102: ////null
103: row++;
104: sheet.Range[row, 2].Value2 = "System.DBNull";
105: sheet.Range[row, 3].Value2 = System.DBNull.Value;
106: sheet.Range[row, 4].Value2 = System.DBNull.Value;
107:
108: ////Empty string
109: row++;
110: sheet.Range[row, 2].Value2 = "Empty string";
111: sheet.Range[row, 3].Value2 = System.String.Empty;
112: sheet.Range[row, 4].Value2 = System.String.Empty;
113:
114: ////Date and time
115: row += 2;
116: title = sheet.Range[row, 2, row, 4];
117: title.Merge();
118: title.Value2 = "Date and time values";
119: title.CellStyle.Font.Italic = true;
120:
121: ////DateTime with default format
122: row++;
123: sheet.Range[row, 2].Value2 = "System.DateTime with default format";
124: sheet.Range[row, 3].Value2 = System.DateTime.Now;
125:
126: ////DateTime with DD-MM-YYYY hh:mm:ss format
127: row++;
128: sheet.Range[row, 2].Value2 = "System.DateTime";
129: sheet.Range[row, 3].Value2 = System.DateTime.Now;
130: sheet.Range[row, 3].NumberFormat = "DD-MM-YYYY hh:mm:ss";
131:
132: ////Date
133: row++;
134: sheet.Range[row, 2].Value2 = " - Date only";
135: sheet.Range[row, 3].Value2 = System.DateTime.Now;
136: sheet.Range[row, 3].NumberFormat = "DD-MM-YYYY";
137:
138: ////Time
139: row++;
140: sheet.Range[row, 2].Value2 = " - Time only";
141: sheet.Range[row, 3].Value2 = System.DateTime.Now;
142: sheet.Range[row, 3].NumberFormat = "hh:mm:ss";
143:
144: ////bool
145: row += 2;
146: sheet.Range[row, 2].Value2 = "System.Boolean (bool)";
147: sheet.Range[row, 3].Value2 = false;
148: sheet.Range[row, 4].Value2 = true;
149:
150: ////Text values
151: row += 2;
152: title = sheet.Range[row, 2, row, 4];
153: title.Merge();
154: title.Value2 = "Text values";
155: title.CellStyle.Font.Italic = true;
156:
157: ////char
158: row++;
159: sheet.Range[row, 2].Value2 = "System.Char (char)";
160: sheet.Range[row, 3].Value2 = 'A';
161:
162: ////single line string
163: row++;
164: sheet.Range[row, 2].Value2 = "System.String (string)";
165: sheet.Range[row, 3].Value2 = "Single line";
166:
167: ////multi line string
168: row++;
169: sheet.Range[row, 2].Value2 = "System.String (string)";
170: sheet.Range[row, 3].Value2 = "Multi line string\nFirst line\nSecond line";
171: sheet.Range[row, 3].WrapText = true;
172:
173: ////StringBuilder
174: row++;
175: sheet.Range[row, 2].Value2 = "System.Text.StringBuilder";
176: sheet.Range[row, 3].Value2 = new System.Text.StringBuilder("StringBuilder text"); 177:
178: //Save workbook
179: book.Save(FileName);
1: Dim builder As New XlsDocumentBuilder()
2: 'create a workbook
3: Dim book As IXlsWorkbook = builder.Create(1)
4:
5: 'Add worksheet
6: Dim sheet As IXlsWorksheet = book.Worksheets(0)
7:
8: '''/header
9: Dim row As Integer = 2
10: sheet.Range(row, 2).Value = "Data type"
11: sheet.Range(row, 3).Value = "Min value"
12: sheet.Range(row, 4).Value = "Max value"
13: sheet.Range(row, 2, row, 4).CellStyle.Font.Bold = True
14:
15: '''/Numberic values
16: row += 2
17: Dim title As IXlsRange = sheet.Range(row, 2, row, 4)
18: title.Merge()
19: title.Value = "Numeric values"
20: title.CellStyle.Font.Italic = True
21:
22: '''/byte
23: row += 1
24: sheet.Range(row, 2).Value2 = "System.Byte (byte)"
25: sheet.Range(row, 3).Value2 = System.[Byte].MinValue
26: sheet.Range(row, 4).Value2 = System.[Byte].MaxValue
27:
28: '''/sbyte
29: row += 1
30: sheet.Range(row, 2).Value2 = "System.SByte"
31: sheet.Range(row, 3).Value2 = System.[SByte].MinValue
32: sheet.Range(row, 4).Value2 = System.[SByte].MaxValue
33:
34: '''/Int16
35: row += 1
36: sheet.Range(row, 2).Value2 = "System.Int16 (short)"
37: sheet.Range(row, 3).Value2 = System.Int16.MinValue
38: sheet.Range(row, 4).Value2 = System.Int16.MaxValue
39:
40: '''/UInt16
41: row += 1
42: sheet.Range(row, 2).Value2 = "System.UInt16 (ushort)"
43: sheet.Range(row, 3).Value2 = System.UInt16.MinValue
44: sheet.Range(row, 4).Value2 = System.UInt16.MaxValue
45:
46: '''/Int32
47: row += 1
48: sheet.Range(row, 2).Value2 = "System.Int32 (int)"
49: sheet.Range(row, 3).Value2 = System.Int32.MinValue
50: sheet.Range(row, 4).Value2 = System.Int32.MaxValue
51:
52: '''/UInt32
53: row += 1
54: sheet.Range(row, 2).Value2 = "System.UInt32 (uint)"
55: sheet.Range(row, 3).Value2 = System.UInt32.MinValue
56: sheet.Range(row, 4).Value2 = System.UInt32.MaxValue
57:
58:
59: '''/Int64
60: row += 1
61: sheet.Range(row, 2).Value2 = "System.Int64 (long)"
62: sheet.Range(row, 3).Value2 = System.Int64.MinValue
63: sheet.Range(row, 4).Value2 = System.Int64.MaxValue
64:
65: '''/UInt64
66: row += 1
67: sheet.Range(row, 2).Value2 = "System.UInt64 (ulong)"
68: sheet.Range(row, 3).Value2 = System.UInt64.MinValue
69: sheet.Range(row, 4).Value2 = System.UInt64.MaxValue
70:
71: '''/Single
72: row += 1
73: sheet.Range(row, 2).Value2 = "System.Single (float)"
74: sheet.Range(row, 3).Value2 = System.[Single].MinValue
75: sheet.Range(row, 4).Value2 = System.[Single].MaxValue
76:
77: '''/Double
78: row += 1
79: sheet.Range(row, 2).Value2 = "System.Double (double)"
80: sheet.Range(row, 3).Value2 = System.[Double].MinValue
81: sheet.Range(row, 4).Value2 = System.[Double].MaxValue
82:
83: '''/Decimal
84: row += 1
85: sheet.Range(row, 2).Value2 = "System.Decimal (decimal)"
86: sheet.Range(row, 3).Value2 = System.[Decimal].MinValue
87: sheet.Range(row, 4).Value2 = System.[Decimal].MaxValue
88:
89: '''/Empty values
90: row += 2
91: title = sheet.Range(row, 2, row, 4)
92: title.Merge()
93: title.Value2 = "Empty values"
94: title.CellStyle.Font.Italic = True
95:
96: '''/null
97: row += 1
98: sheet.Range(row, 2).Value2 = "null"
99: sheet.Range(row, 3).Value2 = Nothing
100: sheet.Range(row, 4).Value2 = Nothing
101:
102: '''/null
103: row += 1
104: sheet.Range(row, 2).Value2 = "System.DBNull"
105: sheet.Range(row, 3).Value2 = System.DBNull.Value
106: sheet.Range(row, 4).Value2 = System.DBNull.Value
107:
108: '''/Empty string
109: row += 1
110: sheet.Range(row, 2).Value2 = "Empty string"
111: sheet.Range(row, 3).Value2 = System.[String].Empty
112: sheet.Range(row, 4).Value2 = System.[String].Empty
113:
114: '''/Date and time
115: row += 2
116: title = sheet.Range(row, 2, row, 4)
117: title.Merge()
118: title.Value2 = "Date and time values"
119: title.CellStyle.Font.Italic = True
120:
121: '''/DateTime with default format
122: row += 1
123: sheet.Range(row, 2).Value2 = "System.DateTime with default format"
124: sheet.Range(row, 3).Value2 = System.DateTime.Now
125:
126: '''/DateTime with DD-MM-YYYY hh:mm:ss format
127: row += 1
128: sheet.Range(row, 2).Value2 = "System.DateTime"
129: sheet.Range(row, 3).Value2 = System.DateTime.Now
130: sheet.Range(row, 3).NumberFormat = "DD-MM-YYYY hh:mm:ss"
131:
132: '''/Date
133: row += 1
134: sheet.Range(row, 2).Value2 = " - Date only"
135: sheet.Range(row, 3).Value2 = System.DateTime.Now
136: sheet.Range(row, 3).NumberFormat = "DD-MM-YYYY"
137:
138: '''/Time
139: row += 1
140: sheet.Range(row, 2).Value2 = " - Time only"
141: sheet.Range(row, 3).Value2 = System.DateTime.Now
142: sheet.Range(row, 3).NumberFormat = "hh:mm:ss"
143:
144: '''/bool
145: row += 2
146: sheet.Range(row, 2).Value2 = "System.Boolean (bool)"
147: sheet.Range(row, 3).Value2 = False
148: sheet.Range(row, 4).Value2 = True
149:
150: '''/Text values
151: row += 2
152: title = sheet.Range(row, 2, row, 4)
153: title.Merge()
154: title.Value2 = "Text values"
155: title.CellStyle.Font.Italic = True
156:
157: '''/char
158: row += 1
159: sheet.Range(row, 2).Value2 = "System.Char (char)"
160: sheet.Range(row, 3).Value2 = "A"c
161:
162: '''/single line string
163: row += 1
164: sheet.Range(row, 2).Value2 = "System.String (string)"
165: sheet.Range(row, 3).Value2 = "Single line"
166:
167: '''/multi line string
168: row += 1
169: sheet.Range(row, 2).Value2 = "System.String (string)"
170: sheet.Range(row, 3).Value2 = "Multi line string" & vbLf & "First line" & vbLf & "Second line"
171: sheet.Range(row, 3).WrapText = True
172:
173: '''/StringBuilder
174: row += 1
175: sheet.Range(row, 2).Value2 = "System.Text.StringBuilder"
176: sheet.Range(row, 3).Value2 = New System.Text.StringBuilder("StringBuilder text") 177:
178: 'Save workbook
179: book.Save(FileName)