[๊ธฐํƒ€] UMD์—์„œ ์ถ”์ถœํ•œ ๋ณด๊ณ ์„œ ํ™•์ธ ๋ฐฉ๋ฒ•

์งˆ๋ฌธ

UMD ์‚ฌ์šฉ ์ค‘ [Excel Report] ๋ฒ„ํŠผ์„ ํด๋ฆญํ•˜์—ฌ ์ถ”์ถœํ•œ ๋ณด๊ณ ์„œ๊ฐ€ ๋ณด์ด์งˆ ์•Š์Šต๋‹ˆ๋‹ค.

ย 

๋‹ต๋ณ€

UMD๋ฅผ ์‹คํ–‰ํ•˜์—ฌ ๊ฐ์ข… ๋ถ€์žฌ์— ๋Œ€ํ•œ ์„ค๊ณ„๊ฐ€ ์™„๋ฃŒ๋œ ํ›„ [Excel Report] ๋ฒ„ํŠผ์„ ํด๋ฆญํ•˜๋ฉด ๋ณด๊ณ ์„œ๋ฅผ ์ถœ๋ ฅํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.
์‚ฌ์šฉ์ž PC ํ™˜๊ฒฝ์— ๋”ฐ๋ผ ํ•ด๋‹น Excel ํŒŒ์ผ์ด ํ™œ์„ฑํ™”๋˜๋Š” ๊ฒฝ์šฐ๋„ ์žˆ๊ณ  PC ๋‚ด์— ๋ฐ”๋กœ ์ž๋™ ์ €์žฅ๋˜๋Š” ๊ฒฝ์šฐ๋„ ์žˆ์Šต๋‹ˆ๋‹ค.
์ด๋Š” ์œ„์— ๋ง์”€๋“œ๋ฆฐ ๋ฐ”์™€ ๊ฐ™์ด ์‚ฌ์šฉ์ž PC ํ™˜๊ฒฝ์— ๋”ฐ๋ผ ์ƒ์ดํ•˜๊ฒŒ ๋ฐœ์ƒํ•˜๋Š” ๊ฒƒ์ด๋ฉฐ, ๋งŒ์•ฝ Excel ํŒŒ์ผ ํ™œ์„ฑํ™”๋ฅผ ํฌ๋งํ•˜์‹ค ๊ฒฝ์šฐ ํฌ๋Ÿผ์„ ํ†ตํ•ด ํŒจ์น˜ ์ง„ํ–‰์„ ๊ถŒ์žฅํ•ฉ๋‹ˆ๋‹ค.
ํŒจ์น˜๊ฐ€ ํ•ด๋‹น ํ˜„์ƒ์— ๋Œ€ํ•œ ํ™•์‹คํ•œ ์กฐ์น˜๋ฒ•์ด๋ผ๊ณ  ์•ˆ๋‚ดํ•˜๋Š”๋ฐ๋Š” ๋ฌด๋ฆฌ๊ฐ€ ์žˆ์œผ๋‚˜ ํŒจ์น˜๋Š” ๊ฐ€์žฅ ์ตœ์ ํ™”๋œ UMD ๊ตฌ๋™ ์ƒํƒœ๋ฅผ ์ œ๊ณตํ•˜๊ณ  ์žˆ์Šต๋‹ˆ๋‹ค.

์•„๋ž˜์—๋Š” ์ถ”์ถœํ•œ ๋ณด๊ณ ์„œ์˜ ExcelํŒŒ์ผ์ด ํ™œ์„ฑํ™”๋˜์ง€ ์•Š์•˜์„ ๋•Œ ์ €์žฅ๋˜๋Š” ๊ฒฝ๋กœ๋ฅผ ์„ค๋ช…ํ•˜๊ณ  ์žˆ์Šต๋‹ˆ๋‹ค.

ย 

1. ์ž‘์—… ํ‘œ์‹œ์ค„ ๊ฒ€์ƒ‰์ฐฝ์— โ€˜๋ฌธ์„œโ€™๋ฅผ ์ž…๋ ฅํ•˜์—ฌ โ€˜๋ฌธ์„œโ€™ ํŒŒ์ผ ํด๋”๋ฅผ ์‹คํ–‰ํ•ฉ๋‹ˆ๋‹ค.
2. ๋ฌธ์„œ ํŒŒ์ผ ํด๋” ๋‚ด์— ์ถœ๋ ฅ๋œ ๋ณด๊ณ ์„œ๋ฅผ ํ™•์ธํ•ฉ๋‹ˆ๋‹ค.

์œ„์— ์•ˆ๋‚ดํ•œ ์œ„์น˜์™€ ๋ณ„๊ฐœ๋กœ ์ง์ ‘ ๋ณด๊ณ ์„œ์˜ ์ถœ๋ ฅ ์œ„์น˜๋ฅผ ์„ค์ •ํ•˜๊ธธ ํฌ๋งํ•  ๊ฒฝ์šฐ ์•„๋ž˜์™€ ๊ฐ™์ด ์ง„ํ–‰ํ•ฉ๋‹ˆ๋‹ค.

ย 

1. ๋ถ€์žฌ ๊ฒ€ํ† ๊ฐ€ ์™„๋ฃŒ๋œ ์ฐฝ ์ขŒ์ธก์— โ€˜Dialogโ€™๋ฅผ ํ™•์ธํ•ฉ๋‹ˆ๋‹ค.
2. Dialog ๋ฉ”๋‰ด ํ•˜๋‹จ ์šฐ์ธก [์„ ํƒํ•ญ๋ชฉ ๊ณ„์‚ฐ] ์˜ค๋ฅธ์ชฝ์— ์žˆ๋Š” [โ–ผ] ๋ฒ„ํŠผ์„ ํด๋ฆญํ•˜์—ฌ Context Menu๋ฅผ ํ™œ์„ฑํ™”ํ•˜๊ณ  [Excel Report]ํด๋ฆญํ•ฉ๋‹ˆ๋‹ค.

๊ทธ๋ฆผ #1 UMD Dialog ๋ฉ”๋‰ด

3. [โ–ผ] ๋ฒ„ํŠผ ์˜† [Excel Report]๋กœ ๋ฐ”๋€ ๋ฒ„ํŠผ์„ ํด๋ฆญํ•ฉ๋‹ˆ๋‹ค.

๊ทธ๋ฆผ #2 Excel Report ๋ฒ„ํŠผ ๋ณ€๊ฒฝ

4. ํ™œ์„ฑํ™”๋œ โ€˜Save Report to Excel Fileโ€™ ์ฐฝ์—์„œ [Save asโ€ฆ] ๋ฒ„ํŠผ์„ ํด๋ฆญํ•ฉ๋‹ˆ๋‹ค.
5. ์ €์žฅ์„ ์›ํ•˜๋Š” ์œ„์น˜ ์„ ํƒ ํ›„ ๋ณด๊ณ ์„œ๋ฅผ ์ถœ๋ ฅํ•ฉ๋‹ˆ๋‹ค.