public void DrawingChart(object[,] data, int sheetNum, ref _Workbook excelBook1, ref Worksheet excelSheet1)
{
excelBook1.Sheets.Add(Type.Missing, excelBook1.Worksheets[sheetNum], 1, System.Type.Missing); //add new sheet
Worksheet sheet = (Worksheet)excelBook1.Worksheets[sheetNum]; //get new sheet
sheet.Name = "Chart sheet"; // sheet name
System.Windows.Forms.DataGridView dgv1 = new System.Windows.Forms.DataGridView();
dgv1.ColumnCount = data[0].Length;
for (int i = 0; i < dgv1.ColumnCount; i++)
{
dgv1.Columns[i].HeaderText = "ColumnName" + i.ToString();
查詢
SELECT COUNT(*) FROM v$session;
SELECT COUNT(*) FROM v$process;
SELECT value FROM v$paramter WHERE name = 'processes';
SELECT value FROM v$paramter WHERE name = 'sessions';
TO_CHAR(0.56, '999990.9') = 0.6
TO_CHAR(0, '999990.9') = 0.0
ROUND(0.56, 1) = 0.6 --還有 floor 無條件捨去
ROUND(0, 1) = 0.0
TRUNC(0.56, 1) = 0.5
this.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch;
string str = "&&";
Excel常用操作屬性
生成excel的時候有時候需要設置單元格的一些屬性,可以參考一下:
public string OpenFile(string fileName)
{
string result = "success";
string path = System.IO.Path.GetDirectoryName(
System.Windows.Forms.Application.ExecutablePath) + "\\" + fileName;
轉貼: http://isc.mdu.edu.tw/isc/isc_page/it/proxy.htm
| 何謂proxy？ |
