Creating and Editing APIs in the .NET Excel Framework

Import and export Excel charting Formulas Template markers Formatting

Import and export

[{"selector":"#anim-c1f56317-14f6-4861-85e3-81046c62909b","keyframes":{"transform":["translate3d(-117.30104%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f676f7e7-dd1f-4152-a645-c929372a9ee2","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-67219a1d-0580-4d89-b703-05df7d3098e8","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-0bccc2c0-a5d9-43a0-9480-f68261c16ef6","keyframes":{"transform":["translate3d(-115.87301%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4055b064-4a50-4eeb-984e-010f668a3801","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-59ffe3cc-d407-4d2e-8911-cab308936513","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] You can import data from a wide range of data sources, HTML tables, and collections. Export data to data tables, collection objects, and even to complex nested classes.

Excel charting

[{"selector":"#anim-cc5f7011-a516-4d75-a34e-ec62a0ba0130","keyframes":{"transform":["translate3d(-117.30104%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-76f71783-e664-4dbc-bc0a-f056d3159317","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-000a51bf-20b8-4553-a084-ccac471aa089","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-c933f834-a325-408c-87ae-26b409e98f72","keyframes":{"transform":["translate3d(-115.87301%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-98058cce-c3b7-420e-99cb-c002db03c0ca","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1bf5c5f2-8481-4448-8d9d-72b4fe66f8b8","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] The Excel Library supports 80+ chart types for data visualization. It also allows the use of sparklines, which are compact charts that visualize data directly within individual cells.

Formulas

[{"selector":"#anim-075a1e23-57b2-4499-9876-07baeab43f6b","keyframes":{"transform":["translate3d(-127.77777%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1c976764-daf6-4e23-9466-5aa921ab3c9a","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0709cf5a-2276-4b90-9275-35b11b7adf86","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-480bf54e-8abc-4500-a3bc-7d0880ca4ae7","keyframes":{"transform":["translate3d(-115.87301%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-42aedd37-efff-447e-973b-6d9772433a10","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5b2da4df-1291-4cbd-a135-9a1c07bf56ef","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] With support for over 400 Excel functions, you can create formula cells. The library also accommodates add-in functions and a wide array of formula types for comprehensive data analysis.

Template markers

[{"selector":"#anim-a115ea65-5baa-42df-a7a4-aba242d4fac5","keyframes":{"transform":["translate3d(-117.30104%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7bc7ac2d-44d9-4b53-b92e-c54ab2b4ba19","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ba487f00-f8ee-475d-9d71-92ee28c90f47","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-1b1b6d72-d1bc-407b-98b0-09d56bfbc359","keyframes":{"transform":["translate3d(-115.87301%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-df26ecce-583b-4e24-8302-61cc74e73e0a","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2a1780c4-8a4f-4285-b38a-7e63cfbbe756","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] Import data into Excel with functionality similar to Word's mail merge, allowing seamless data integration. Additionally, the library supports customized data import options to meet specific needs.

Formatting

[{"selector":"#anim-8caf071c-bb27-493f-bbeb-88ae152a314b","keyframes":{"transform":["translate3d(-117.30104%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-14f1c5b4-4a76-40c2-9f6d-9626063ac4a9","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f06c489b-c6dc-4675-ae2d-64156ad75be5","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-5256caf4-b7cb-418d-b741-95d9341080fa","keyframes":{"transform":["translate3d(-115.87301%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-cf1455dc-5d2c-40fb-b049-dec225fe94b2","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0d57cbaa-5162-47c7-8e45-d8b3080e1d65","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] Utilize a wide range of cell and text formatting, combined with advanced conditional formatting features, to customize the appearance of your data for better presentation and analysis.

FOLLOW US ON SOCIAL MEDIA

[{"selector":"#anim-29a203b9-dafa-401a-8772-b64a4fa4c9ac","keyframes":{"transform":["scale(1)","scale(1.5)","scale(0.95)","scale(1)"],"offset":[0,0.33,0.66,1]},"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-22c4dcd9-2017-48d6-835c-acd9d5cf20ea","keyframes":{"transform":["scale(1)","scale(1.5)","scale(0.95)","scale(1)"],"offset":[0,0.33,0.66,1]},"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-f6796a4d-2869-4d81-9aca-f55cb047a313","keyframes":{"transform":["scale(1)","scale(1.5)","scale(0.95)","scale(1)"],"offset":[0,0.33,0.66,1]},"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-aa07eb1e-0f4f-4d75-bce0-9be8b515ab9c","keyframes":{"transform":["scale(1)","scale(1.5)","scale(0.95)","scale(1)"],"offset":[0,0.33,0.66,1]},"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}]