- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Reflection;
- using MSExcel = Microsoft.Office.Interop.Excel;
- namespace ConsoleApplication2
- {
- class shelf
- {
- private MSExcel.Application appExcel;
- private MSExcel.Workbook excelDoc;
- private object format = MSExcel.XlFileFormat.xlWorkbookNormal;
- private Object Nothing = Missing.Value;
- static void Main(string[] args)
- {
- //CreateShelf();
- shelf s = new shelf();
- s.SaveToExcel();
- }
- private void SaveToExcel()
- {
- appExcel = new MSExcel.Application();
- excelDoc = appExcel.Workbooks.Add(Nothing);
- MSExcel.Worksheet ws = (MSExcel.Worksheet)excelDoc.Sheets[1];
- string s;
- for (int i = 1; i <= 6; i++)
- {
- s = "a" + i;
- MSExcel.Range r = ws.get_Range(s, s);
- //向第一列单元格赋值
- r.Value2 = i;
- }
- MSExcel.Range r2 = ws.get_Range("b1", "b1");
- //向第1行第2列单元格赋值
- r2.Value2 = "05-4-01";
- excelDoc.SaveAs("G://aa.xlsx", Nothing, Nothing, Nothing, Nothing, Nothing,
- MSExcel.XlSaveAsAccessMode.xlExclusive, Nothing, Nothing, Nothing, Nothing,Nothing);
- excelDoc.Close(Nothing, Nothing, Nothing);
- appExcel.Quit();
- }
- private static void CreateShelf()
- {
- int line;
- Console.Write("输入排数:");
- line = Convert.ToInt32(Console.ReadLine());
- int ShelfNumber, LayerNumber;
- Console.Write("输入货架数:");
- ShelfNumber = Convert.ToInt32(Console.ReadLine());
- Console.Write("输入层数:");
- LayerNumber = Convert.ToInt32(Console.ReadLine());
- int[] Number = new int[ShelfNumber];
- for (int i = 0; i < ShelfNumber; i++)
- {
- Console.WriteLine("第{0}个货架列数:", i + 1);
- Number[i] = Convert.ToInt32(Console.ReadLine());
- }
- int n;
- for (int i = LayerNumber; i > 0; i--)
- {
- n = 1;
- for (int j = 0; j < ShelfNumber; j++)
- {
- Console.Write("|");
- for (int k = 0; k < Number[j]; k++)
- {
- Console.Write("{2}-{0}-{1}|", i, n.ToString().PadLeft(2, '0'), line.ToString().PadLeft(2, '0'));
- n++;
- }
- Console.Write(" ");
- }
- Console.WriteLine();
- }
- }
- }
- }