Xporter 0.2.2-alpha

This is a prerelease version of Xporter.
Install-Package Xporter -Version 0.2.2-alpha
dotnet add package Xporter --version 0.2.2-alpha
<PackageReference Include="Xporter" Version="0.2.2-alpha" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Xporter --version 0.2.2-alpha
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Xporter, 0.2.2-alpha"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install Xporter as a Cake Addin
#addin nuget:?package=Xporter&version=0.2.2-alpha&prerelease

// Install Xporter as a Cake Tool
#tool nuget:?package=Xporter&version=0.2.2-alpha&prerelease
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Xporter

CI

"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.

  • .NETStandard 2.0

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
0.2.2-alpha 716 4/19/2021
0.2.1-alpha 62 4/19/2021
0.1.9-alpha 79 4/2/2021
0.1.8-alpha 41 4/2/2021
0.1.7-alpha 83 3/31/2021
0.1.6-alpha 55 3/30/2021
0.1.5-alpha 77 3/29/2021
0.1.4-alpha 56 3/29/2021
0.1.3-alpha 55 3/29/2021
0.1.2-alpha 67 3/29/2021
0.1.1-alpha 101 3/10/2021
0.1.0-alpha 76 3/3/2021

Updated (NEW) prerelease version 0.2.2
-New added LoadTempl(with sheet name) +1 overload method
-New added WriteToCells now writes in all sheets or
WriteToCells(with sheet name) overload method write to the specified sheet