一、如何在EXCEL表中的数据录入时显示，信息已经录入

通过数据有效性、自定义有效性条件，公式中输入“=countif(a:a,a2)=1”。请不要加引号

二、怎么解决每次打开Office 2013都提示配置进度

修改注册表的方法解决Office启动配置问题

1

保证你的Office 2013已经激活

2

打开注册表，在开始菜单下的搜索框中输入regedit，按Enter键

3

到HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Word\Options，右侧找到NoRereg，右键修改

4

将值从0改为1，保存退出

5

如果没有找到NoRereg注册表，那就新建一个DWORD（32位）值，命名为NoRereg，然后将数值数据改为1即可

END

运行对话框中输入命令解决Office启动配置问

同时按Win键+R键调出运行框，如图

在运行对话框中输入以下命令，然后点确定即可：reg add HKCU\Software\Microsoft\Office\15.0\Word\Options /v NoReReg /t REG_DWORD /d 1

如果其他版本的Office软件，如每次打开Office 2003/2007/2010都是先显示“安装程序正在准备必要的文件”，提示配置进度，那么分别按照本法在运行框输入指令，点击确定即可

Office 2003用的命令：reg add HKCU\Software\Microsoft\Office\11.0\Word\Options /v NoReReg /t REG_DWORD /d 1

Office 2007用的命令：reg add HKCU\Software\Microsoft\Office\12.0\Word\Options /v NoReReg /t REG_DWORD /d 1

Office 2010用的命令：reg add HKCU\Software\Microsoft\Office\14.0\Word\Options /v NoReReg /t REG_DWORD /d 1

三、C#中EXCEL表格的内容导入到数据库中进度条怎么实现

可参考以下例子：

public void ExportToExcel()

{

DataTable dt = getDataTable();

if (dt == null)

{

MessageBox.Show(没有数据可供导出！, 提示, MessageBoxButtons.OK, MessageBoxIcon.Information);

return;

}

Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();

if (xlApp == null)

{

MessageBox.Show(无法创建Excel对象，可能您的电脑未安装Excel);

return;

}

System.Windows.Forms.SaveFileDialog saveDia = new SaveFileDialog();

saveDia.Filter = Excel文件(*.xls)|*.xls;

saveDia.Title = 导出为Excel文件;

if (saveDia.ShowDialog() == System.Windows.Forms.DialogResult.OK

&& !string.Empty.Equals(saveDia.FileName))

{

Microsoft.Office.Interop.Excel.Workbooks workbooks = xlApp.Workbooks;

Microsoft.Office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);

Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];//取得sheet1

Microsoft.Office.Interop.Excel.Range range = null;

long totalCount = dt.Rows.Count;

long rowRead = 0;

float percent = 0;

string fileName = saveDia.FileName;

//写入标题

for (int i = 0; i < dt.Columns.Count; i++)

{

worksheet.Cells[1, i + 1] = dt.Columns[i].ColumnName;

range = (Microsoft.Office.Interop.Excel.Range)worksheet.Cells[1, i + 1];

//range.Interior.ColorIndex = 15;//背景颜色

range.Font.Bold = true;//粗体

range.Font.Size = 11;//字体大小

range.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;//居中

//加边框

range.BorderAround(Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous, Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin, Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic, null);

//range.ColumnWidth = 4.63;//设置列宽

//range.EntireColumn.AutoFit();//自动调整列宽

//r1.EntireRow.AutoFit();//自动调整行高

}

//写入内容

for (int r = 0; r < dt.DefaultView.Count; r++)

{

this.state.Text = 正在导出数据......已导出 + (r + 1).ToString() + 条/共 + dataGridView1.Rows.Count.ToString() + 条;

this.progressBar1.Value = r + 1;

for (int i = 0; i < dt.Columns.Count; i++)

{

worksheet.Cells[r + 2, i + 1] = dt.DefaultView[r][i];

range = (Microsoft.Office.Interop.Excel.Range)worksheet.Cells[r + 2, i + 1];

range.Font.Size = 10;//字体大小

//加边框

range.BorderAround(Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous, Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin, Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic, null);

range.EntireColumn.AutoFit();//自动调整列宽

}

rowRead++;

percent = ((float)(100 * rowRead)) / totalCount;

System.Windows.Forms.Application.DoEvents();

}

range.Borders[Microsoft.Office.Interop.Excel.XlBordersIndex.xlInsideHorizontal].Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin;

if (dt.Columns.Count > 1)

{

range.Borders[Microsoft.Office.Interop.Excel.XlBordersIndex.xlInsideVertical].Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin;

}

workbook.Saved = true;

workbook.SaveCopyAs(fileName);

workbooks.Close();

if (xlApp != null)

{

xlApp.Workbooks.Close();

xlApp.Quit();

int generation = System.GC.GetGeneration(xlApp);

System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp);

xlApp = null;

System.GC.Collect(generation);

}

GC.Collect();//强行销毁

#region 强行杀死最近打开的Excel进程

System.Diagnostics.Process[] excelProc = System.Diagnostics.Process.GetProcessesByName(EXCEL);

System.DateTime startTime = new DateTime();

int m, killId = 0;

for (m = 0; m < excelProc.Length; m++)

{

if (startTime < excelProc[m].StartTime)

{

startTime = excelProc[m].StartTime;

killId = m;

}

}

if (excelProc[killId].HasExited == false)

{

excelProc[killId].Kill();

}

#endregion

if (MessageBox.Show(this, 数据已经成功导出到： + saveDia.FileName.ToString() + ,是否打开文件？, 导出完成, MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)

{

System.Diagnostics.Process.Start(saveDia.FileName);

}

}

else

{

GC.Collect();//强行销毁

#region 强行杀死最近打开的Excel进程

System.Diagnostics.Process[] excelProc = System.Diagnostics.Process.GetProcessesByName(EXCEL);

System.DateTime startTime = new DateTime();

int m, killId = 0;

for (m = 0; m < excelProc.Length; m++)

{

if (startTime < excelProc[m].StartTime)

{

startTime = excelProc[m].StartTime;

killId = m;

}

}

if (excelProc[killId].HasExited == false)

{

excelProc[killId].Kill();

}

#endregion

}

panel2.Visible = false;

}

#endregion