OpenXML SDK(C#): Copy all comments from one Excel workbook to another -


i have 1 workbook has data comments - , have copy of same workbook without comments.

i want put comments in second workbook. tried appending comments 1 file , it's not working.

here have tried far...

spreadsheetdocument docwithcomments = spreadsheetdocument.open(@"...\comments.xlsx", true); spreadsheetdocument docwithoutcomments = spreadsheetdocument.open(@"...\nocomments.xlsx", true); workbookpart wbpwithcomments = docwithcomments.workbookpart; workbookpart wbpwithoutcomments = docwithoutcomments.workbookpart;  (int = 0; < wbpwithcomments.worksheetparts.count(); i++) {     if (wbpwithoutcomments.worksheetparts.elementat(i).worksheetcommentspart == null)     {         wbpwithoutcomments.worksheetparts.elementat(i).addnewpart<worksheetcommentspart>();         wbpwithoutcomments.worksheetparts.elementat(i).worksheetcommentspart.comments = new comments();         wbpwithoutcomments.worksheetparts.elementat(i).worksheetcommentspart.comments.commentlist = new commentlist();     }     (int j = 0; j < wbpwithcomments.worksheetparts.elementat(i).worksheetcommentspart.comments.count(); j++)     {         var = wbpwithcomments.worksheetparts.elementat(i).worksheetcommentspart.comments.commentlist.elementat(j);         wbpwithoutcomments.worksheetparts.elementat(i).worksheetcommentspart.comments.commentlist.append(a.clonenode(true));         var b = wbpwithoutcomments.worksheetparts.elementat(i).worksheetcommentspart.comments.commentlist.elementat(j);     } }

this code running without errors second workbook not showing comments.

tell me if there better way available complete task? in advance.


Comments

Post a Comment

Popular posts from this blog

4x4 Matrix in Python -

im trying code 4x4 matrix in python random integers 1-4. thats easy enough problem want each row , each column 1 time uses of each digit 1-4 example 1 2 3 4 2 3 4 1 3 4 1 2 4 1 2 3 my code 33% of time in loop there happens somthing this 2 1 4 3 3 4 2 1 1 3 x <-------- because of programm cant contiune , end in infinity loop helb how can out? code below """ programm playing game skyline """ random import randrange row1 = [] row2 = [] row3 = [] row4 = [] allrows = [row1, row2, row3, row4] column1 = [] column2 = [] column3 = [] column4 = [] allcolumns = [column1, column2, column3, column4] def board(): in range(4): j = 0 while len(allrows[i]) != 4: x = randrange(1,5) print(i, j) if x not in allrows[i] , x not in allcolumns[j]: allrows[i].append(x) allcolumns[j].append(x) j += 1 else: continue boa...
Read more

python - String indices must be integers and while issue -

i writing code school homework. assignment this: write code read book codes till "000" entered , split books 2 categories depending on first 4 digits entered isbn , issn. note : use str , check prefix of code (in case isbn , issn). here code: bookarray = [] booknumber = str(input("give me book code - type 000 if want cancel")) while booknumber != "000": bookarray.append(booknumber) booknumber = str(input("give me book code - type 000 if want cancel")) if booknumber[0,4] == "isbn": isbnarray = booknumber elif booknumber[0,4] == "issn": issnarray = booknumber print(issnarray) print(isbnarray) any regarding same appreciated! in first year in python @ school. edit: expected output should 2 lists books' code numbers. currently, face autonomous loop on "while" not sure of how , why. if booknumber[0,4] == "isbn": you're passing tuple index booknumber ex...
Read more

python - PyInstaller UAC not working in onefile mode -

hello everybody. i have small python project , want make single executable file . using... windows 7 python 3.4 pyinstaller 3.2.1 my pyinstaller command is, pyinstaller -y -w -f -n output_file_name --uac-admin --clean source_file.py this command works properly. single output file not ask admin rights when executed. , there's no shield mark on executable file icon. when remove -f option (equivalent --onefile), output executable file has shield mark on icon , ask me admin rights. not want. want single executable file. i found manifest file (output_file_name.exe.manifest) in dist\output_file_name folder. did... pyinstaller -y -w -f -n output_file_name --manifest output_file_name.exe.manifest --uac-admin --clean source_file.py but command doesn't work. single executable file still not ask admin rights. i have removed pyinstaller , installed recent development version. pip install git+https://github.com/pyinstaller/pyinstaller.git@develop but result...
Read more