Microsoft MVP성태의 닷넷 이야기
.NET : 3. Open XML을 다루는 코드 스니핏 [링크 복사], [링크+제목 복사],
조회: 10430
글쓴 사람
정성태 (techsharer at outlook.com)
홈페이지
첨부 파일
 

[블로그 출처]
Code Snippets for Open XML Development
; https://docs.microsoft.com/en-us/archive/blogs/dmahugh/code-snippets-for-open-xml-development

2007 Office System Sample: Open XML File Format Code Snippets for Visual Studio 2005
; http://www.microsoft.com/downloads/details.aspx?FamilyID=8d46c01f-e3f6-4069-869d-90b8b096b556&displaylang=en

아무래도, 이전 Office 2003보다는 "Open XML"로 된 Office 2007이 다루기에는 좀 더 쉬워졌음은 명백한 것 같습니다.

이와 관련된 MSDN Magazine 토픽은 다음을 참조하십시오.
Setting Word Document Properties the Office 2007 Way
; https://docs.microsoft.com/en-us/archive/msdn-magazine/2006/june/msdn-magazine-june-2006


"2007 Office System Sample"에는 다음과 같은 코드 조각들을 예제로 담고 있다고 합니다.

----------------------------------------------------------------------------
- Open XML: Get OfficeDocument Part

---------------------- Excel 2007
- Excel: Add Custom UI
- Excel: Delete Comments by a specific User
- Excel: Delete Worksheet
- Excel: Delete Excel 4.0 Macro sheets
- Excel: Retrieve hidden rows or columns
- Excel: Export Chart
- Excel: Get Cell Value
- Excel: Get Comments as XML
- Excel: Get Hidden Worksheets
- Excel: Get Worksheet Information
- Excel: Get Cell for Reading
- Excel: Get Cell for Writing
- Excel: Insert Custom XML
- Excel: Insert Header or Footer
- Excel: Insert a Numeric Value into a Cell
- Excel: Insert a String Value into a Cell
- Excel: Set Recalc Option

---------------------- Powerpoint 2007
- PowerPoint: Delete Comments by User
- PowerPoint: Delete Slide by Title
- PowerPoint: Get Slide Count
- PowerPoint: Get Slide Titles
- PowerPoint: Modify Slide Title
- PowerPoint: Reorder Slides
- PowerPoint: Replace Image
- PowerPoint: Retrieve Slide Location by Title

---------------------- Word 2007
- Word: Accept Revisions
- Word: Add Header
- Word: Convert DOCM to DOCX
- Word: Remove Comments
- Word: Remove Headers and Footers
- Word: Remove Hidden Text
- Word: Replace Style
- Word: Retrieve Application Property
- Word: Retrieve Core Property
- Word: Retrieve Custom Property
- Word: Retrieve Table of Contents
- Word: Set Application Property
- Word: Set Core Property
- Word: Set Custom Property
- Word: Set Print Orientation








[최초 등록일: ]
[최종 수정일: 3/25/2022]


비밀번호

댓글 작성자
 



2022-03-25 12시33분
MiniExcel - Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet
; https://github.com/MiniExcel/MiniExcel
정성태

1  2  3  4  5  6  7  [8]  9  10  11  12  13  14  15  ...
NoWriterDateCnt.TitleFile(s)
1001정성태12/31/200810191.NET : 95. 빌드된 어셈블리를 서명하는 방법 [1]
1000정성태12/29/200810283Code Contracts
999정성태12/17/200811197Visual C++ : 14. Visual Studio 2010 - MSBuild
998정성태12/16/200812016.NET 3.0 : 26. WPF - HostVisual?
997정성태12/10/200811885.NET : 94. Native C++ 클래스를 상속받는 C# 클래스 정의
996정성태12/9/200812260.NET : 93. Document Reflector [1]
995정성태12/1/200811845Visual C++ : 13. Detours 라이브러리
993정성태11/30/200811788.NET 3.0 : 25. C# Extension 의 좋은 활용 예 - 오피스 Interop API Extensions
992정성태11/30/200816873.NET : 92. Application.DoEvents 의 부작용
991정성태11/26/200813957.NET 4.0: 6. Thread Pool 개선
990정성태11/25/200811563개발 환경 구성: 124. Hyper-V 와 도메인 컨트롤러
989정성태11/21/200811065IIS : 24. IIS7 - Process and Thread Identity in ASP.NET
988정성태11/9/200811314.NET 4.0: 5. C# 4.0 새기능들(2008년10월CTP버젼)
987정성태11/5/200811600.NET 4.0: 4. What's New in the BCL in .NET 4.0 [2]
986정성태11/3/200810846.NET 4.0: 3. Dump 디버깅 지원
985정성태10/30/200810553.NET 4.0: 2. .NET 4.0 포스터
984정성태10/30/200810915.NET 4.0: 1. No PIA
983정성태10/29/200810845Visual C++ : 12. Visual C++ 10
982정성태10/29/200812213.NET : 91. WPF Toolkit
981정성태10/27/200811257.NET : 90. Microsoft Chart control for .NET Framework
980정성태10/24/200811081Debug : 38. StackOverflow Notifier
979정성태10/24/200810681SDK : 15. ESENT (Extensible Storage Engine) API in the Windows SDK
978정성태10/23/200810970TFS : 170. TeamReview 도구
977정성태10/15/200813072.NET : 89. DotNetZip - ZIP 압축을 위한 닷넷 라이브러리
976정성태10/15/200810760TFS : 169. tf.exe 명령어 - workspaces /remove 와 workspaces /delete 의 차이
975정성태10/9/200810698.NET : 88. ClickOnce에서 .application 파일을 다운로드 하려고 할 때.
1  2  3  4  5  6  7  [8]  9  10  11  12  13  14  15  ...