HTML
JS
Result
Skip Results Iframe
EDIT ON
Live
Live
This Pen is owned by
Mescius Korea
on
CodePen
.
See more by @MESCIUS-Korea on CodePen
External CSS
https://cdn.mescius.com/spreadjs/hosted/css/gc.spread.sheets.excel2013white.18.0.6.css
https://cdn.mescius.co.kr/installers/SpreadJS/demo/18.0.6/gc.spread.sheets.designer.18.0.6.min.css
https://cdn.mescius.co.kr/installers/SpreadJS/demo/18.0.6/custom.css
External JavaScript
https://code.jquery.com/jquery-latest.js
https://cdn.mescius.com/spreadjs/hosted/scripts/gc.spread.sheets.all.18.0.6.min.js
https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.shapes.18.0.6.min.js
https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.charts.18.0.6.min.js
https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.slicers.18.0.6.min.js
https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.print.18.0.6.min.js
https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.barcode.18.0.6.min.js
https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.pdf.18.0.6.min.js
https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.pivot.pivottables.18.0.6.min.js
https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.tablesheet.18.0.6.min.js
https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.ganttsheet.18.0.6.min.js
https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.formulapanel.18.0.6.min.js
https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.report.reportsheet.18.0.6.min.js
https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.io.18.0.6.min.js
https://cdn.mescius.com/spreadjs/hosted/scripts/interop/gc.spread.excelio.18.0.6.min.js
https://cdn.mescius.com/spreadjs/hosted/scripts/resources/ko/gc.spread.sheets.resources.ko.18.0.6.min.js
https://cdn.mescius.co.kr/installers/SpreadJS/demo/18.0.6/gc.spread.sheets.designer.resource.ko.18.0.6.min.js
https://cdn.mescius.co.kr/installers/SpreadJS/demo/18.0.6/gc.spread.sheets.designer.all.18.0.6.min.js
https://cdn.mescius.co.kr/installers/license/codepen_v18.js
https://cdn.mescius.co.kr/installers/license/codepen_v18_designer.js
{"__browser":{"country":"US","device":"unknown_device","mobile":false,"name":"unknown browser","platform":"unknown_platform","version":"0"},"__constants":{},"__CPDATA":{"domain_iframe":"https://cdpn.io","environment":"production","host":"codepen.io","iframe_allow":"accelerometer *; ambient-light-sensor *; camera *; display-capture *; encrypted-media *; geolocation *; gyroscope *; microphone *; midi *; payment *; serial *; vr *; web-share *; xr-spatial-tracking *","iframe_sandbox":"allow-downloads allow-forms allow-modals allow-pointer-lock allow-popups allow-popups-to-escape-sandbox allow-presentation allow-same-origin allow-scripts allow-top-navigation-by-user-activation"},"__graphql":{"data":{"errors":[{"message":"Cannot return null for non-nullable field Query.sessionUser"}],"data":null},"url":"https://codepen.io/graphql","api":"cprails"},"__pay_stripe_public_key":"pk_live_2GndomDfiklqpSNQn8FrGuwZSMIMzha7DkLJqlYe7IR0ihKAlKdiHg68JJc5eVPt68rzAjzAAVXcUwjySHRCsgjQQ00gtRBUFNH","__pay_braintree_env":"production","__boomboom":{"serve_url":"https://cdpn.io/cpe/boomboom","store_url":"https://codepen.io/cpe/boomboom/store"},"__pageType":"embed","__item":"{\"editor_settings\":{\"auto_run\":true,\"autocomplete\":false,\"code_folding\":true,\"css_pre_processor\":\"none\",\"css_prefix\":\"neither\",\"css_starter\":\"neither\",\"emmet_active\":true,\"font_size\":14,\"font_type\":\"system\",\"format_on_save\":false,\"html_pre_processor\":\"none\",\"indent_with\":\"spaces\",\"js_pre_processor\":\"none\",\"key_bindings\":\"normal\",\"line_numbers\":true,\"line_wrapping\":true,\"match_brackets\":true,\"snippets\":{\"markupSnippets\":{},\"stylesheetSnippets\":{}},\"tab_size\":2,\"theme\":\"twilight\",\"id\":\"poEEEEX\",\"auto_save\":true},\"hashid\":\"poEEEEX\",\"itemType\":\"pen\",\"resources\":[{\"url\":\"https://code.jquery.com/jquery-latest.js\",\"order\":0,\"resource_type\":\"js\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.com/spreadjs/hosted/css/gc.spread.sheets.excel2013white.18.0.6.css\",\"order\":0,\"resource_type\":\"css\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.com/spreadjs/hosted/scripts/gc.spread.sheets.all.18.0.6.min.js\",\"order\":1,\"resource_type\":\"js\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.co.kr/installers/SpreadJS/demo/18.0.6/gc.spread.sheets.designer.18.0.6.min.css\",\"order\":1,\"resource_type\":\"css\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.co.kr/installers/SpreadJS/demo/18.0.6/custom.css\",\"order\":2,\"resource_type\":\"css\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.shapes.18.0.6.min.js\",\"order\":2,\"resource_type\":\"js\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.charts.18.0.6.min.js\",\"order\":3,\"resource_type\":\"js\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.slicers.18.0.6.min.js\",\"order\":4,\"resource_type\":\"js\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.print.18.0.6.min.js\",\"order\":5,\"resource_type\":\"js\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.barcode.18.0.6.min.js\",\"order\":6,\"resource_type\":\"js\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.pdf.18.0.6.min.js\",\"order\":7,\"resource_type\":\"js\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.pivot.pivottables.18.0.6.min.js\",\"order\":8,\"resource_type\":\"js\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.tablesheet.18.0.6.min.js\",\"order\":9,\"resource_type\":\"js\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.ganttsheet.18.0.6.min.js\",\"order\":10,\"resource_type\":\"js\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.formulapanel.18.0.6.min.js\",\"order\":11,\"resource_type\":\"js\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.report.reportsheet.18.0.6.min.js\",\"order\":12,\"resource_type\":\"js\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.io.18.0.6.min.js\",\"order\":13,\"resource_type\":\"js\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.com/spreadjs/hosted/scripts/interop/gc.spread.excelio.18.0.6.min.js\",\"order\":14,\"resource_type\":\"js\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.com/spreadjs/hosted/scripts/resources/ko/gc.spread.sheets.resources.ko.18.0.6.min.js\",\"order\":15,\"resource_type\":\"js\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.co.kr/installers/SpreadJS/demo/18.0.6/gc.spread.sheets.designer.resource.ko.18.0.6.min.js\",\"order\":16,\"resource_type\":\"js\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.co.kr/installers/SpreadJS/demo/18.0.6/gc.spread.sheets.designer.all.18.0.6.min.js\",\"order\":17,\"resource_type\":\"js\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.co.kr/installers/license/codepen_v18.js\",\"order\":18,\"resource_type\":\"js\",\"par_content\":\"\"},{\"url\":\"https://cdn.mescius.co.kr/installers/license/codepen_v18_designer.js\",\"order\":19,\"resource_type\":\"js\",\"par_content\":\"\"}],\"tags\":[],\"id\":48919264,\"user_id\":975719,\"html\":\"<div id=\\\"gc-designer-container\\\"></div>\",\"css\":\"\",\"js\":\"window.onload = function () {\\n // Initialize designer with default configuration and above created spread component\\n var designer = new GC.Spread.Sheets.Designer.Designer(document.getElementById(\\\"gc-designer-container\\\"));\\n\\n // initialize Spread\\n var spread = designer.getWorkbook();\\n // Get the activesheet\\n var sheet = spread.getSheet(0);\\n // Set Column Width\\n sheet.setColumnWidth(2, 100);\\n sheet.setColumnWidth(4, 100);\\n // Create Data Array\\n var dataArray =\\n [\\n ['Region', 'Subregion', 'country', 'Population'],\\n ['Asia', 'Southern', 'India', 1354051854],\\n [, , 'Pakistan', 200813818],\\n [, , 'Bangladesh', 166368149],\\n [, , 'Others', 170220300],\\n [, 'Eastern', 'China', 1415045928],\\n [, , 'Japan', 127185332],\\n [, , 'Others', 111652273],\\n [, 'South-Eastern', , 655636576],\\n [, 'Western', , 272298399],\\n [, 'Central', , 71860465],\\n ['Africa', 'Eastern', , 433643132],\\n [, 'Western', , 381980688],\\n [, 'Northern', , 237784677],\\n [, 'Others', , 234512021],\\n ['Europe', , , 742648010],\\n ['Others', , , 1057117703]\\n ];\\n // Set Array\\n sheet.setArray(1, 1, dataArray);\\n var treemapChart = sheet.charts.add('chart1', GC.Spread.Sheets.Charts.ChartType.treemap, 450, 0, 500, 500, \\\"B2:E18\\\");\\n};\",\"html_pre_processor\":\"none\",\"css_pre_processor\":\"none\",\"js_pre_processor\":\"none\",\"html_classes\":\"\",\"css_starter\":\"neither\",\"js_library\":null,\"created_at\":\"2020-12-09T07:34:20.000Z\",\"updated_at\":\"2025-04-10T04:06:21.955Z\",\"title\":\"SpreadJS 디자이너 컴포넌트 V18.0.6_홈페이지 게시 전용\",\"description\":\"\",\"slug_hash\":\"poEEEEX\",\"head\":\"<meta name=\\\"spreadjs culture\\\" content=\\\"ko-kr\\\" />\\n<meta charset=\\\"utf-8\\\" />\",\"private\":false,\"has_animation\":false,\"team_id\":0,\"css_prefix\":\"neither\",\"template\":false,\"parent_id\":0,\"comments_count\":0,\"custom_screenshot_filename\":null,\"loves_count\":1,\"pick\":false,\"popularity\":100,\"views_count\":950,\"pick_visible_at\":null,\"cpid\":\"0176466c-2060-7db1-a810-32370679b94e\",\"is_new_editor_pen\":false,\"access\":\"Public\",\"pen_hash\":null}","__processorsMap":{"autoprefixer":"autoprefixer-10","babel":"babel-7","coffeescript":"coffeescript-2","format-1":"format-1","flutter":"flutter-1","haml":"haml-4","less":"less-3","lint-1":"lint-1","livescript":"livescript-1","markdown":"markdown-11","postcss":"postcss-7","pug":"pug-2","sass":"sass-1","scss":"sass-1","sass-ruby-3":"sass-ruby-3","sass-ruby-compass-3":"sass-ruby-compass-3","slim":"slim-3","stylus":"stylus-0","typescript":"typescript-4","vue":"vue-2","vue3":"vue-3"},"__favicon_mask_icon":"https://cpwebassets.codepen.io/assets/favicon/logo-pin-b4b4269c16397ad2f0f7a01bcdf513a1994f4c94b8af2f191c09eb0d601762b1.svg","__favicon_shortcut_icon":"https://cpwebassets.codepen.io/assets/favicon/favicon-aec34940fbc1a6e787974dcd360f2c6b63348d4b1f4e06c77743096d55480f33.ico","__path_to_iframe_console_runner":"https://cpwebassets.codepen.io/assets/editor/iframe/iframeConsoleRunner-6d8bf8b4b479137260842506acbb12717dace0823c023e08b96360e60b0840d9.js","__path_to_iframe_refresh_css":"https://cpwebassets.codepen.io/assets/editor/iframe/iframeRefreshCSS-44fe83e49b63affec96918c9af88c0d80b209a862cf87ac46bc933074b8c557d.js","__path_to_iframe_runtime_errors":"https://cpwebassets.codepen.io/assets/editor/iframe/iframeRuntimeErrors-4f205f2c14e769b448bcf477de2938c681660d5038bc464e3700256713ebe261.js","__path_to_processor_worker":"https://cpwebassets.codepen.io/assets/packs/router.js","__path_to_stop_execution_on_timeout":"https://cpwebassets.codepen.io/assets/common/stopExecutionOnTimeout-2c7831bb44f98c1391d6a4ffda0e1fd302503391ca806e7fcc7b9b87197aec26.js","__pen_normalize_css_url":"https://public.codepenassets.com/css/normalize-5.0.0.min.css","__pen_prefix_free_url":"https://public.codepenassets.com/js/prefixfree-1.0.7.min.js","__pen_reset_css_url":"https://public.codepenassets.com/css/reset-2.0.min.css"}