程序博客网 > 暗黑3mac版下载

C# 操作Excel

来源：互联网 发布：暗黑3mac版下载 编辑：程序博客网 时间：2024/06/07 02:57

[置顶]2中读取Excel方法

--------------------------------------------------------------------方法一

[html] view plaincopyprint?
  1. /// <summary>
  2. /// 解析Excel，返回DataTable
  3. /// </summary>
  4. /// <paramname="fileName"></param>
  5. /// <returns></returns>
  6. public static System.Data.DataTable ImpExcel(string fileName)
  7. {
  8. System.Data.DataTable dt = new System.Data.DataTable();
  9. try
  10. {
  11. Microsoft.Office.Interop.Excel.Application app;
  12. Workbooks wbs;
  13. Worksheet ws;
  14. app = new Microsoft.Office.Interop.Excel.Application();
  15. wbs = app.Workbooks;
  16. wbs.Add(fileName);
  17. ws = (Worksheet)app.Worksheets.get_Item(1);
  18. int a = ws.Rows.Count;
  19. int b = ws.Columns.Count;
  20. string name = ws.Name;
  22. for (int i = 1; i<RowCount; i++)
  23. {
  24. DataRow dr = dt.NewRow();
  25. for (int j = 1; j <= ColumnsCount; j++)
  26. {
  27. Range range = ws.get_Range(app.Cells[i, j], app.Cells[i, j]);
  28. range.Select();
  29. dr[j - 1] = app.ActiveCell.Text.ToString();
  30. }
  31. dt.Rows.Add(dr);
  32. }
  33. KillProcess(app);
  34. return dt;
  35. }
  36. catch (Exception ex)
  37. {
  38. MessageBox.Show("数据绑定Excel失败! 失败原因：Excel格式不正确！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
  39. return dt;
  40. }
  41. }
  42. <SPANstyle="COLOR: #ff0000">-------------------------------------------<SPANstyle="FONT-SIZE: 24px">方法二</SPAN></SPAN>
  43. /// <summary>
  44. /// 解析Excel，根据OleDbConnection直接连Excel
  45. /// </summary>
  46. /// <paramname="filePath"></param>
  47. /// <paramname="name"></param>
  48. /// <returns></returns>
  49. public static DataSet LoadDataFromExcel(string filePath, string name)
  50. {
  51. try
  52. {
  53. string strConn;
  54. // strConn = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = " + filePath + ";ExtendedProperties=Excel 8.0";
  55. strConn = @"Provider=Microsoft.ACE.OLEDB.12.0;DataSource=" + filePath + ";ExtendedProperties=\"Excel 12.0 Xml;HDR=No\"";
  56. OleDbConnection OleConn = new OleDbConnection(strConn);
  57. OleConn.Open();
  58. string sql = "SELECT * FROM [" + name + "$]";//可是更改Sheet名称，比如sheet2，等等
  59. OleDbDataAdapter OleDaExcel =new OleDbDataAdapter(sql, OleConn);
  60. DataSet OleDsExcle = new DataSet();
  61. OleDaExcel.Fill(OleDsExcle, name);
  62. OleConn.Close();
  63. return OleDsExcle;
  64. }
  65. catch (Exception err)
  66. {
  67. MessageBox.Show("数据绑定Excel失败! 失败原因：" + err.Message, "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
  68. return null;
  69. }
  70. }


——————————————————插入Excel

[csharp] view plaincopyprint?
  1. /// <summary>
  2. /// 写入Excel文档
  3. /// </summary>
  4. /// <param name="Path">文件名称</param>
  5. public bool SaveFP2toExcel(string Path)
  6. {
  7. try
  8. {
  9. string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source="+ Path +";"+"Extended Properties=Excel 8.0;";
  10. OleDbConnection conn = new OleDbConnection(strConn);
  11. conn.Open();
  12. System.Data.OleDb.OleDbCommand cmd=new OleDbCommand ();
  13. cmd.Connection =conn;
  14. for(int i=0;i<fp2.Sheets [0].RowCount -1;i++)
  15. {
  16. if(fp2.Sheets [0].Cells[i,0].Text!="")
  17. {
  18. cmd.CommandText ="INSERT INTO [sheet1$] (工号,姓名,部门,职务,日期,时间) VALUES('"+fp2.Sheets [0].Cells[i,0].Text+"','"+
  19. fp2.Sheets [0].Cells[i,1].Text+"','"+fp2.Sheets [0].Cells[i,2].Text+"','"+fp2.Sheets [0].Cells[i,3].Text+
  20. "','"+fp2.Sheets [0].Cells[i,4].Text+"','"+fp2.Sheets [0].Cells[i,5].Text+"')";
  21. cmd.ExecuteNonQuery ();
  22. }
  23. }
  24. conn.Close ();
  25. return true;
  26. }
  27. catch(System.Data.OleDb.OleDbException ex)
  28. {
  29. System.Diagnostics.Debug.WriteLine ("写入Excel发生错误："+ex.Message );
  30. }
  31. return false;
  32. }


新增、修改

[csharp] view plaincopyprint?
  1. string path="你的excel的路径";
  2. workbook book=new workbook(path);
  3. worksheet sheet=book["sheet3"];
  4. sheet[行，列]=“你想存的值";
  5. workbook.saveas(newpath);



——————————————————修改Excel的值

[csharp] view plaincopyprint?
  1. 修改第一行Name的值为张三
  2. string strComm = "update [Sheet1$] set Name='张三' WHERE 工号='132'";
  3. OleDbConnection myConn = new OleDbConnection(strConn);
  4. myConn.Open();
  5. OleDbCommand com = new OleDbCommand(strComm, myConn);
  6. com.ExecuteNonQuery();
  7. myConn.Close();

------------------------------------------------导出————————————————————

[csharp] view plaincopyprint?
  1. using _Excel = Microsoft.Office.Interop.Excel;
  2. using System.Drawing;
  3. using System.Reflection;
  4. using System.Windows.Forms;
  5. using Microsoft.Office.Interop.Excel;
  6. /// <summary>
  7. /// DataTable直接导出Excel,此方法会把DataTable的数据用Excel打开,再自己手动去保存到确切的位置
  8. /// </summary>
  9. /// <param name="dt">要导出Excel的DataTable</param>
  10. /// <returns></returns>
  11. public staticvoid ExportExcel(System.Data.DataTable table,string savePath, bool isExit)
  12. {
  13. if (!isExit)//保存路径是否存在
  14. File.Copy(System.Windows.Forms.Application.StartupPath + @"\Excel\Excel.xls", savePath);
  15. _Excel.Application app = new _Excel.ApplicationClass();
  16. if (app == null)
  17. {
  18. throw new Exception("Excel无法启动");
  19. }
  20. app.Visible = false;
  21. _Excel.Workbook book = app.Workbooks.Open(savePath, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing);
  22. _Excel.Worksheet sheet = (_Excel.Worksheet)book.ActiveSheet;
  24. for (int k = 1; k < ds.Tables[1].Rows.Count + 1; k++)
  25. {
  26. _Excel.Sheets xlSheets = book.Sheets as Sheets;
  27. // 添加 Sheet
  28. sheet = (Worksheet)xlSheets.Add(xlSheets[1], Type.Missing, Type.Missing, Type.Missing);
  29. }
  30. for (int j = 1; j < ds.Tables[1].Rows.Count + 1; j++)
  31. {
  33. _Excel.Range range = null;
  34. sheet = (_Excel.Worksheet)book.Sheets[j];
  35. if (!istrue)
  36. sheet.Name ="123";
  37. else
  38. sheet.Name = "345";
  39. range = sheet.get_Range("A1","C3");
  40. range.MergeCells = true;//合并，将1-3行和1-3列合并为一个单元格
  41. range.WrapText = true;//自动换行
  42. range.EntireRow.AutoFit();//行高根据内容自动调整
  43. sheet.get_Range("A1","C3").Borders[XlBordersIndex.xlEdgeBottom].LineStyle = BorderStyle.FixedSingle;//将1-3行和1-3列合并的单元格划下划线，根据[]内属性，可以设置文本上、下、左、右的的边框框
  44. sheet.get_Range("A1", "C3").Borders.LineStyle = BorderStyle.FixedSingle;//给整个合并的单元格加上边框
  45. sheet.get_Range("A1","C3").Font.Name = "Times New Roman";//设置字体.
  46. sheet.get_Range("A1", "C3").Font.Size = 22;//设置字体大小
  47. range.Font.Bold = true;//加粗
  48. range.RowHeight = 22;//调行高
  49. rang.Interior.Color = System.Drawing.Color.FromArgb(255, 204, 153).ToArgb();//加背景色
  50. range = sheet.get_Range(string.Format("D{0}", 1),string.Format("F{0}", 1));
  51. range.MergeCells = true;//合并，将3-5列合并为一个单元格
  52. range.HorizontalAlignment = XlHAlign.xlHAlignCenter;//合并后文本水平居中
  53. range.VerticalAlignment = XlVAlign.xlVAlignCenter;//合并后文本竖直居中
  54. 單個sheet里求和：
  55. Excel.Range range2 = sheet.get_Range("B25", Type.Missing);
  56. range2.Formula = "=SUM(B2:B24)";
  57. range2.Calculate();
  59. rang = (_Excel.Range)sheet.get_Range(string.Format("G{0}", 7),string.Format("G{0}", table.Rows.Count + 7));
  60. rang.NumberFormatLocal = "$#,##0.00";//设置单元格格式为货币格式
  61. 跨sheet求和：
  62. Excel.Worksheet wsheet1 = (Excel.Worksheet)excelSql.Worksheets.get_Item(1);
  63. Excel.Range range3 =wsheet1.get_Range("A23", Type.Missing);
  64. range3.Formula = "=Sheet3!B8+Sheet3!B12";
  65. range3.Calculate();
  66. sheet.Cells[1, 4] = ds.Tables[1].Rows[0]["FeightCode"].ToString();//给合并的列赋值
  67. //循环加载数据
  68. int startIndex = 0;
  69. for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
  70. {
  71. if (ds.Tables[1].Rows[j - 1]["BoxCode"].ToString() == ds.Tables[0].Rows[i]["BoxCode"].ToString())
  72. {
  73. range = sheet.get_Range("b" + (15 + startIndex) +"", "e" + (15 + startIndex) +"");
  74. range.MergeCells = true;
  75. sheet.Cells[15 + startIndex, 2] = ds.Tables[0].Rows[i]["TypeName"].ToString();
  76. range = (_Excel.Range)sheet.Cells[15 + startIndex, 2];
  77. range.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  78. range.Font.Bold = true;
  79. range.RowHeight = 22;
  80. sheet.Cells[15 + startIndex, 6] = ds.Tables[0].Rows[i]["Qty"].ToString();
  81. range = (_Excel.Range)sheet.Cells[15 + startIndex, 6];
  82. range.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  83. range.Font.Bold = true;
  84. range.RowHeight = 22;
  85. sheet.Cells[15 + startIndex, 7] = ds.Tables[0].Rows[i]["UnitPrice"].ToString();
  86. range = (_Excel.Range)sheet.Cells[15 + startIndex, 7];
  87. range.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  88. range.Font.Bold = true;
  89. range.RowHeight = 22;
  90. sheet.Cells[15 + startIndex, 8] = ds.Tables[0].Rows[i]["Subtotal"].ToString();
  91. range = (_Excel.Range)sheet.Cells[15 + startIndex, 8];
  92. range.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  93. range.Font.Bold = true;
  94. range.RowHeight = 22;
  95. Image image = Picture.ReadPicture(ds.Tables[0].Rows[row][col].ToString());
  96. range = sheet.get_Range(string.Format("A{0}", row * num + 29),string.Format("A{0}", row * num + 48));
  97. sheet.Shapes.AddPicture(ds.Tables[0].Rows[row][col].ToString(), Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoTrue, Convert.ToSingle(range.Left) + 15 + image.Width, Convert.ToSingle(range.Top) + 5, image.Width, image.Height); //导出图片
  98. range.EntireColumn.AutoFit();
  99. System.Windows.Forms.Application.DoEvents();
  100. startIndex++;
  101. }
  102. }
[csharp] view plaincopyprint?
  1. rang = sheet.get_Range("a" + (table.Rows.Count + 3) +"", "r" + (table.Rows.Count + 3) +"");
  2. rang.Font.Bold = true;
  3. rang.Interior.Color = System.Drawing.Color.FromArgb(255, 204, 153).ToArgb();//设置单元格背景颜色
[csharp] view plaincopyprint?
  1. sheet.Columns.AutoFit();
  2. sheet.Cells.EntireColumn.AutoFit();
  3. sheet.Columns.EntireColumn.AutoFit();//列宽自适应。
  4. // sheet.Cells.Borders.LineStyle =BorderStyle.Fixed3D;//设置边框
  5. sheet = null;
  6. book.Save();
  7. }
  8. book.Close(sheet, savePath, System.Type.Missing);
  9. app.Quit();
  10. app.DisplayAlerts=false; //保存Excel的时候，不弹出是否保存的窗口直接进行保存
  11. System.GC.Collect();
  12. KillProcess(app);
  14. /// <summary>
  15. /// 导出Excel后，杀死Excel进程
  16. /// </summary>
  17. /// <param name="app"></param>
  18. private staticvoid KillProcess(_Excel.Application app)
  19. {
  20. IntPtr t = new IntPtr(app.Hwnd);
  21. int k = 0;
  22. GetWindowThreadProcessId(t, out k);
  23. System.Diagnostics.Process p = System.Diagnostics.Process.GetProcessById(k);
  24. p.Kill();
  25. }
  26. [DllImport("User32.dll", CharSet = CharSet.Auto)]
  27. public staticextern int GetWindowThreadProcessId(IntPtr hwnd,out int ID);

C#导出写保护的Excel，设置某些区域可以编辑
对Excel操作时，由于使用权限的不同，可能对表格的操作权限也不一样。EXCEL提供了保护工作表以及允许编辑单元格功能。相应的在C#中就可以对Excel表格进行操作。
有两种方法可以实现：
第一种：
[csharp] view plaincopyprint?
  1. 主要用Protect（）方法保护工作表，Worksheet.Protection.AllowEditRanges设置允许编辑的单元格。
  2. public void CreateExcel()
  3. {
  4. //创建一个Excel文件
  5. Microsoft.Office.Interop.Excel.Application myExcel = new Microsoft.Office.Interop.Excel.Application();
  6. Microsoft.Office.Interop.Excel.Workbook excelWorkbook = null;
  7. Microsoft.Office.Interop.Excel.Worksheet excelSheet = null;
  8. myExcel.Application.Workbooks.Add(true);
  9. //让Excel文件可见
  10. myExcel.Visible = true;
  11. myExcel.Cells[1, 4] = "普通报表";
  12. //逐行写入数据
  13. for (int i = 0; i < 11; i++)
  14. {
  15. for (int j = 0; j < 7; j++)
  16. {
  17. //以单引号开头，表示该单元格为纯文本
  18. myExcel.Cells[2 + i, 1 + j] = "'" + i;
  19. }
  20. }
  21. try
  22. {
  23. string excelTemp ="c:\\a.xls";
  24. //excelWorkbook = myExcel.Workbooks[1];
  25. excelWorkbook = myExcel.ActiveWorkbook;
  26. excelSheet = (Microsoft.Office.Interop.Excel.Worksheet)excelWorkbook.ActiveSheet;
  28. //设定允许操作的单元格
  29. Microsoft.Office.Interop.Excel.AllowEditRanges ranges = excelSheet.Protection.AllowEditRanges;
  30. ranges.Add("Information", myExcel.Application.get_Range("B2","B2"), Type.Missing);
  31. //保护工作表
  32. excelSheet.Protect("MyPassword", Type.Missing, Type.Missing, Type.Missing,
  33. Type.Missing, Type.Missing, Type.Missing, Type.Missing,
  34. Type.Missing, Type.Missing, Type.Missing, Type.Missing,
  35. Type.Missing, true, Type.Missing, Type.Missing);
  36. //Realease the com object
  37. System.Runtime.InteropServices.Marshal.ReleaseComObject(excelSheet);
  38. excelSheet = null;
  40. //Save the result to a temp path
  41. excelWorkbook.SaveAs(excelTemp, Excel.XlFileFormat.xlWorkbookNormal,null, null,false, false,
  42. Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing,
  43. Type.Missing, Type.Missing,Type.Missing,Type.Missing);
  44. }
  45. catch (Exception ex)
  46. {
  47. throw;
  48. }
  49. finally
  50. {
  51. if (excelWorkbook !=null)
  52. {
  53. System.Runtime.InteropServices.Marshal.ReleaseComObject(excelWorkbook);
  54. excelWorkbook = null;
  55. }
  56. if (myExcel != null)
  57. {
  58. myExcel.Workbooks.Close();
  59. myExcel.Quit();
  60. System.Runtime.InteropServices.Marshal.ReleaseComObject(myExcel);
  61. myExcel = null;
  62. }
  63. GC.Collect();
  64. }
  65. }
  66. PS：借用此方法我写了个循环来设定单元格保护，没想到一直在报HRESULT:0x800A03EC 的一个异常，郁闷。
  67. 经过一番折腾，发现 AllowEditRanges.Add方法的第一个参数名是不能够重复的，写循环的时候没注意。

第二种：
用locked属性，设置Locked = false 的区域就可编辑的区域

[csharp] view plaincopyprint?
  1. worksheet.get_Range(worksheet.Cells[1, 1], worksheet.Cells[10, 10]).Locked =false;
  2. //保护工作表
  3. worksheet.Protect("MyPassword", Type.Missing, Type.Missing, Type.Missing,
  4. Type.Missing, Type.Missing, Type.Missing, Type.Missing,
  5. Type.Missing, Type.Missing, Type.Missing, Type.Missing,
  6. Type.Missing, true, true,true);
  9. ///
  10. /// 在工作表中插入行，并调整其他行以留出空间
  11. ///
  12. ///
  13. 当前工作表
  14. ///
  15. 欲插入的行索引
  16. private void InsertRows(Excel.Worksheet sheet,int rowIndex)
  17. {
  18. range = (Excel.Range)sheet.Rows[rowIndex, missing];
  19. //object Range.Insert(object shift, object copyorigin);
  20. //shift: Variant类型，可选。指定单元格的调整方式。可以为下列 XlInsertShiftDirection 常量之一：
  21. //xlShiftToRight 或 xlShiftDown。如果省略该参数，Microsoft Excel 将根据区域形状确定调整方式。
  22. range.Insert(Excel.XlInsertShiftDirection.xlShiftDown, missing);
  23. }
  25. ///
  26. /// 在工作表中删除行
  27. ///
  28. ///
  29. 当前工作表
  30. ///
  31. 欲删除的行索引
  32. private void DeleteRows(Excel.Worksheet sheet,int rowIndex)
  33. {
  34. range = (Range)sheet.Rows[rowIndex, missing];
  35. range.Delete(Excel.XlDeleteShiftDirection.xlShiftUp);
  36. }
  38. ///
  39. /// 退出Excel，并且释放调用的COM资源
  40. ///
  41. private void Dispose()
  42. {
  43. book.Close(missing, missing, missing);
  44. app.Workbooks.Close();
  45. app.Quit();
  46. }



----------------------------NOPI导出Excel-------------------------------

改单元格样式点击打开链接

[csharp] view plaincopyprint?
  1. dll下载地址：<A href="http://download.csdn.net/detail/happy09li/4436160" target=_blank>点击打开链接</A>
  2. using NPOI;
  3. using NPOI.HPSF;
  4. using NPOI.HSSF;
  5. using NPOI.HSSF.UserModel;
  6. public staticvoid exportExcel(DataTable dtSource, string strFileName)
  7. {
  8. HSSFWorkbook workbook = new HSSFWorkbook();
  9. HSSFSheet sheet = workbook.CreateSheet();
  10. //填充表头
  11. HSSFRow dataRow = sheet.CreateRow(0);
  12. HSSFCellStyle headStyle = workbook.CreateCellStyle();
  13. headStyle.Alignment = CellHorizontalAlignment.CENTER;
  14. HSSFFont font = workbook.CreateFont();
  15. font.FontHeightInPoints = 20;
  16. font.Boldweight = 700;
  17. headStyle.SetFont(font);
  19. foreach (DataColumn columnin dtSource.Columns)
  20. {
  21. dataRow.CreateCell(column.Ordinal).SetCellValue(column.ColumnName);
  22. dataRow.GetCell(column.Ordinal).CellStyle = headStyle;
  23. // dataRow.GetCell(column.Ordinal).c
  24. //设置列宽
  25. //sheet.SetColumnWidth(column.Ordinal,column.Caption.Length*20);
  26. }
  27. //填充内容
  28. for (int i = 0; i < dtSource.Rows.Count; i++)
  29. {
  30. dataRow = sheet.CreateRow(i + 1);
  31. for (int j = 0; j < dtSource.Columns.Count; j++)
  32. {
  33. dataRow.CreateCell(j).SetCellValue(dtSource.Rows[i][j].ToString());
  34. }
  35. }</pre><pre name="code"class="csharp">for (int m = 0; m < dtData.Columns.Count - 1; m++)
  36. {
  37. for (int n = 0; n < dtData.Rows.Count - 1; n++)
  38. {
  39. if (sheet.GetRow(n).GetCell(m).ToString() == sheet.GetRow(n + 1).GetCell(m).ToString() && !string.IsNullOrEmpty(sheet.GetRow(n).GetCell(m).ToString()))
  40. {
  41. sheet.AddMergedRegion(new NPOI.HSSF.Util.Region(n, m, n + 1, m));
  42. }
  43. //else if (sheet.GetRow(n).GetCell(m).ToString() == sheet.GetRow(n).GetCell(m + 1).ToString())
  44. //{
  45. // sheet.AddMergedRegion(new Region(n, m, n, m + 1));
  46. //}
  47. }
  48. }
  49. //保存
  50. using (MemoryStream ms = new MemoryStream())
  51. {
  52. using (FileStream fs = new FileStream(strFileName, FileMode.Create, FileAccess.Write))
  53. {
  54. workbook.Write(fs);
  55. }
  56. }
  57. workbook.Dispose();
  58. }
暗黑3mac版下载 暗黑3mac版下载
原创粉丝点击
热门IT博客
淘宝飞利浦是正品吗淘宝飞利浦是正品吗
php webservice接口php webservice接口
数据分析师收入
卫生网络直报系统网址
滴滴打车软件介绍
约妹子软件
网络播放器怎么安装
java 内部类构造函数
淘宝假冒商品申诉
手机淘宝联盟登录失效
淘宝店铺轮播图片
java银行系统开发
pc破解软件论坛
起点推荐位数据
淘宝盗用别人的图片
mac os 10.12正式版
马耳他综合指南 知乎
大学生书籍推荐知乎
中国不高兴知乎
js 鼠标轨迹特效
热门问题 老师的惩罚 人脸识别 我在镇武司摸鱼那些年 重生之率土为王 我在大康的咸鱼生活 盘龙之生命进化 天生仙种 凡人之先天五行 春回大明朝 姑娘不必设防，我是瞎子 平底锅哪个好 生煎平底锅 平底锅哪个牌子好 铁锅和不粘锅哪个好 美的平底锅 平底锅可以做什么美食 苏泊尔平底锅 平底锅可以炒菜吗 平底锅做蛋糕 懒人平底锅菜谱 爱仕达平底锅 用平底锅做披萨 电磁平底锅 平底锅推荐 平底锅订做 平底锅厂家 烧烤平底锅 平底锅哪个牌子好用 平底锅蛋糕 平底锅鸡蛋卷 平底锅哪个品牌好 平底锅哪个牌子的好 平底锅 牌子 平底锅 价格 平底锅什么牌子好用 韩式平底锅 无油烟平底锅 平底锅早餐 平底锅和炒锅的区别 不锈钢平底锅价格 双立人平底锅价格 平底锅那个牌子好 平底锅清洗 怎么选平底锅 平底锅怎么用 平底锅排名 平底锅排行 平底锅三件套 平底锅适合炒菜吗 平底锅好用吗 不锈钢 平底锅

程序博客网，程序员的互联网技术博客家园。csdn论坛精品 msdn技术资料都在这里