๐Ÿ’ป Back-End

[ASP.NET][C#] All About Office Interop (Excel)

์˜ฌใ„น1๋ธŒ 2018. 5. 10. 13:21
๋ฐ˜์‘ํ˜•

# COM Interop

 

COM Interop์€ ๋‹ท๋„ท ํ”„๋ ˆ์ž„์›Œํฌ (.NET Framework)์—์„œ ๊ณตํ†ต ์–ธ์–ด ๋Ÿฐํƒ€์ž„(CLR)์— ํฌํ•จ๋œ ์ปดํฌ๋„ŒํŠธ ์˜ค๋ธŒ์ ํŠธ ๋ชจ๋ธ(COM) ๊ฐœ์ฒด๋ฅผ ์ƒํ˜ธ ์šด์šฉํ•  ์ˆ˜ ์žˆ๊ฒŒ ๋งŒ๋“œ๋Š” ๊ธฐ์ˆ ์ด๋‹ค.


=> ์–ด๋ ต๊ฒŒ๋„ ์„ค๋ช…ํ•œ๋‹ค... (๊ฐœ์ธ์ ์ธ ์ƒ๊ฐ)

COM Interop์€ ๋‹ท๋„ท ํ”„๋ ˆ์ž„์›Œํฌ์—์„œ COM ๊ฐœ์ฒด๋ฅผ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๊ฒŒ ๋งŒ๋“  ๊ธฐ์ˆ .


# Office Interop 


# C#์—์„œ ์—‘์…€ ์ž๋™ํ™”


 https://m.blog.naver.com/PostView.nhn?blogId=duskfallz&logNo=40103427782&proxyReferer=https%3A%2F%2Fwww.google.co.kr%2F



# Excel์—์„œ RowsCount, ColumnsCount ๊ตฌํ•˜๊ธฐ


 

Microsoft.Office.Interop.Excel (package) 

ใ„ด WorkSheet              (Interface)


Q. ๋‹จ์ˆœํ•œ Sheet์˜ Row ์นด์šดํŠธ, Column ์นด์šดํŠธ ๊ตฌํ•˜๋ ค๋ฉด?

A. sheet(๋ณ€์ˆ˜๋ช…).Rows.Count / sheet(๋ณ€์ˆ˜๋ช…).Columns.Count

=> Sheet์˜ ์ตœ๋Œ€ ๋ฒ”์œ„๋ฅผ ๊ฐ€์ ธ์˜ต๋‹ˆ๋‹ค. (๊ฐ’์ด ์—†๋Š” ๋ฒ”์œ„๊นŒ์ง€๋„ ๊ฐ€์ ธ์˜ฌ ๊ฐ€๋Šฅ์„ฑ ๋†ํ›„)


Q. ๊ทธ๋ ‡๋‹ค๋ฉด ๊ฐ’์ด ์œ ํšจํ•œ Cell์˜ ๋ฒ”์œ„๋ฅผ ๊ฐ€๋ฆฌํ‚ค๋Š” Row ์นด์šดํŠธ, Column ์นด์šดํŠธ ๊ตฌํ•˜๋ ค๋ฉด?

A. sheet(๋ณ€์ˆ˜๋ช…).UsedRange.Rows.Count / sheet(๋ณ€์ˆ˜๋ช…).UsedRange.Columns.Count


#[์ถœ์ฒ˜] http://jinmy.tistory.com/16



๋ฐ˜์‘ํ˜•
์ €์ž‘์žํ‘œ์‹œ ๋น„์˜๋ฆฌ ๋ณ€๊ฒฝ๊ธˆ์ง€

'๐Ÿ’ป Back-End' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๋‹ค๋ฅธ ๊ธ€

Telegram Bot API  (0) 2019.10.01
[JEUS] Session Timeout ์„ค์ •  (0) 2019.02.13
[Web] #Servlet #GET #POST  (0) 2018.07.24
[ASP.NET][C#] EXIF ํƒœ๊ทธ ์ฝ๊ธฐ  (1) 2018.03.13
[๋™๊ธฐ vs ๋น„๋™๊ธฐ]  (0) 2017.11.16

'๐Ÿ’ป Back-End'์˜ ๋‹ค๋ฅธ๊ธ€

  • ํ˜„์žฌ๊ธ€[ASP.NET][C#] All About Office Interop (Excel)

๊ด€๋ จ๊ธ€

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”