我有DateTable.需要在teplate文档中插入它而不是某些字符集.
我可以用这种方式替换文本到文本(很多missingObj以避免错误)：
using Word = Microsoft.Office.Interop.Word;
Word._Application application;
Word._Document document;
Object missingObj = System.Reflection.Missing.Value;
Object trueObj = true;
Object falSEObj = false;
private void create_button1_Click(object sender,EventArgs e) {
application = new Word.Application();
Object templatePathObj;
templatePathObj = "template.dot";
try {
document = application.Documents.Add(ref templatePathObj,ref missingObj,ref missingObj);
}
catch (Exception error) {
document.Close(ref falSEObj,ref missingObj,ref missingObj);
application.Quit(ref missingObj,ref missingObj);
document = null;
application = null;
throw error;
}
object strToFindobj = "%%mark%%";
object replaceStrObj = "text to replace";
Word.Range wordRange;
object replaceTypeObj;
replaceTypeObj = Word.WdReplace.wdReplaceAll;
for (int i = 1; i <= document.Sections.Count; i++) {
wordRange = document.Sections[i].Range;
Word.Find wordFindobj = wordRange.Find;
object[] wordFindParameters = new object[15] { strToFindobj,missingObj,replaceStrObj,replaceTypeObj,missingObj };
wordFindobj.GetType().InvokeMember("Execute",BindingFlags.InvokeMethod,null,wordFindobj,wordFindParameters);
}
application.Visible = true;
}
我必须改变所以这个代码将采用DataTable而不是strToFindobj？
在这个例子中,我替换Range中的东西,什么是文档的碎片,包括表格,格式等.
解决方法
lots of missingObj to avoid the bugs
目标.Net 4.0或更高版本支持COM调用的命名和可选参数,因此您不需要包含所有ref missingObj.请参阅此MSDN文章：Named and Optional Arguments – 此功能极大地方便了对COM接口(如Microsoft Office Automation API)的调用.
What do I have to change so I can search using a
DataTableinstead
of string variablestrToFindobj?
您必须遍历DataTables Row和Cell替换Word文档中的DataTable单元格,例如：
foreach(var dr in dt.Rows)
{
foreach (var cell in dr.ItemArray)
{
string strToFind = cell.ToString();
string replaceStr = "replace old value";
ReplaceTextInWord(@"C:\Temp\template.docx",strToFind,replaceStr);
}
}
如果您发现太难使用DataTable并且想要一个更容易的列表(如字典)：
var listofTextToReplace = new Dictionary<string,string>();
listofTextToReplace.Add("%%mark%%","text to replace");
foreach(var item in listofTextToReplace )
{
string strToFind = item.Key;
string replaceStr = item.Value;
ReplaceTextInWord(@"C:\Temp\template.docx",replaceStr);
}
这是ReplaceTextInWord方法：
using Word = Microsoft.Office.Interop.Word;
Word._Application application;
Word._Document document;
Object missingObj = System.Reflection.Missing.Value;
Object trueObj = true;
Object falSEObj = false;
private void create_button1_Click(object sender,EventArgs e) {
//ReplaceTextInWord("template.dot","find me","Found"); <-- Are you sure you want to replace in a Template?
ReplaceTextInWord(@"C:\Temp\template.docx","%%mark%%","text to replace"); //I think you want a .DOC or DOCX file
}
private void ReplaceTextInWord(string wordDocFilePath,string strToFind,string replaceStr) {
application = new Word.Application();
try {
//document = application.Documents.Add(ref templatePathObj,ref missingObj);
document = application.Documents.Open(wordDocFilePath); //You need to open Word Documents,not add them,as per https://msdn.microsoft.com/en-us/library/tcyt0y1f.aspx
}
catch (Exception error) {
document.Close(ref falSEObj,ref missingObj);
application.Quit(ref missingObj,ref missingObj);
document = null;
application = null;
throw error;
}
for (int i = 1; i <= document.Sections.Count; i++) {
Word.Range wordRange = document.Sections[i].Range;
Word.Find findobject = wordRange.Find;
findobject.ClearFormatting();
findobject.Text = strToFind;
findobject.Replacement.ClearFormatting();
findobject.Replacement.Text = replaceStr;
object replaceAll = Word.WdReplace.wdReplaceAll;
findobject.Execute(ref missing,ref missing,ref replaceAll,ref missing);
}
application.Visible = true;
}
参考MSDN：How to: Programmatically Search for and Replace Text in Documents