Xporter 0.2.2-alpha

Xporter

"Xporter" allows users to export Spreadsheet files easily from either any object type or list of properties as a source, using pre-existing .xlsx files as Templates.

Contents

The problem

Installation

How to use

ToDo

License

The problem

Imagine having different types of data and you want to export them easily in an xlsx file. You may need this at your work, to present any kind of statistics.. Its necessary to have a service that exports any kind of data that you will provide to it.

Like the method above:

public static void InsertData(List<object> objects)
{
}

Instalation

[Using NuGet]

Search into the NuGet (prerelease) packages the library or run the following command:

PM> Install-Package Xporter.Core -Version 0.2.0-alpha

[Manual]

• Download this repository: <a href="https://github.com/dimgrev/Xporter/archive/main.zip" target="_blank">here</a>
• Unzip downloaded file
• Copy the resulting folder to app/Plugin
• Rename the folder you copied to utilityXporter

[GIT Submodule]

In your app directory type:

  git submodule add -b master git://github.com/dimgrev/Xporter.git 
Plugin/utilityXporter
  git submodule init
  git submodule update

[GIT Clone]

In your Plugin directory type:

  git clone -b master git://github.com/dimgrev/Xporter.git 
UtilityXporter

Usage

To use this library, add a using statement for Xporter {using Xporter;}

Now you can call the base static class named "Xport."

and on that class call one of three methods:

* Xport.LoadFromFileInfo()
* Xport.LoadFromFileStream()
* Xport.CreateNewPackage()

Then you can use the library extensions methods listed below as you like:

* .LoadTempl()		+1 overload	--> to load a template from another xlsx file to the current one
* .InsertData()		+2 overloads	--> to insert any kind of data from a model all other source
* .WriteToCells()	+1 overload	--> to write something in specified cells
* .Clear()		+1 overload	--> to clear the data of a worksheet or clear all sheets of a file

ToDo

• Add method Insert-inTo-Cells based on the content that cells hold <br> ** eg. insertToCells(cell's value: string "< Insert Here > ", value to insert: string "Put This into that cell");

• Maybe - Change Xlsx File's style

License

The MIT License (MIT)

Copyright ©2021 Dimitris Grevenos

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.