개정판 5b3801e5
issue #1059: Upload ReportApp
Change-Id: I166e2b5edc4636b77d077989ebe851639879575d
ReportApp/ReportApp.sln | ||
---|---|---|
1 |
|
|
2 |
Microsoft Visual Studio Solution File, Format Version 12.00 |
|
3 |
# Visual Studio 15 |
|
4 |
VisualStudioVersion = 15.0.28307.902 |
|
5 |
MinimumVisualStudioVersion = 10.0.40219.1 |
|
6 |
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "ReportApp", "ReportApp\ReportApp.csproj", "{CDFD9B99-29FD-4E54-B51D-BEF9F275A94F}" |
|
7 |
EndProject |
|
8 |
Global |
|
9 |
GlobalSection(SolutionConfigurationPlatforms) = preSolution |
|
10 |
Debug|Any CPU = Debug|Any CPU |
|
11 |
Release|Any CPU = Release|Any CPU |
|
12 |
EndGlobalSection |
|
13 |
GlobalSection(ProjectConfigurationPlatforms) = postSolution |
|
14 |
{CDFD9B99-29FD-4E54-B51D-BEF9F275A94F}.Debug|Any CPU.ActiveCfg = Debug|Any CPU |
|
15 |
{CDFD9B99-29FD-4E54-B51D-BEF9F275A94F}.Debug|Any CPU.Build.0 = Debug|Any CPU |
|
16 |
{CDFD9B99-29FD-4E54-B51D-BEF9F275A94F}.Release|Any CPU.ActiveCfg = Release|Any CPU |
|
17 |
{CDFD9B99-29FD-4E54-B51D-BEF9F275A94F}.Release|Any CPU.Build.0 = Release|Any CPU |
|
18 |
EndGlobalSection |
|
19 |
GlobalSection(SolutionProperties) = preSolution |
|
20 |
HideSolutionNode = FALSE |
|
21 |
EndGlobalSection |
|
22 |
GlobalSection(ExtensibilityGlobals) = postSolution |
|
23 |
SolutionGuid = {B4BBDBA6-854A-46EF-A56B-C48338EFBD22} |
|
24 |
EndGlobalSection |
|
25 |
EndGlobal |
ReportApp/ReportApp/App.config | ||
---|---|---|
1 |
<?xml version="1.0" encoding="utf-8"?> |
|
2 |
<configuration> |
|
3 |
<startup> |
|
4 |
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6.1"/> |
|
5 |
</startup> |
|
6 |
</configuration> |
ReportApp/ReportApp/Program.cs | ||
---|---|---|
1 |
using System; |
|
2 |
using System.Collections.Generic; |
|
3 |
using System.Linq; |
|
4 |
using System.Text; |
|
5 |
using System.Threading.Tasks; |
|
6 |
using GemBox.Spreadsheet; |
|
7 |
|
|
8 |
namespace ConsoleApp1 |
|
9 |
{ |
|
10 |
class Program |
|
11 |
{ |
|
12 |
static void Main(string[] args) |
|
13 |
{ |
|
14 |
SpreadsheetInfo.SetLicense("SN-2021May25-IPYYaC5T2J/LIzFImndeajkkMS/Fn1fLWGfjRRxTNu/uan2hm9KrTK/v9hdsQfLCOuUeMZXrEHCPsmS7Pnp4YGIGsOw==A"); |
|
15 |
//string[] arg = new string[] { "D:/Projects/HYTOS/Docs/P-9203_20210427.xlsx", "C:\\Users\\shj\\AppData\\Local\\Temp\\tmpc35x0f14.svg"}; |
|
16 |
string Execl_Path = args[0]; |
|
17 |
string Svg_Path = args[1].Replace("\\", "/"); |
|
18 |
|
|
19 |
var workbook = ExcelFile.Load(Execl_Path); |
|
20 |
|
|
21 |
foreach (var worksheet in workbook.Worksheets) |
|
22 |
{ |
|
23 |
worksheet.Pictures.Add(Svg_Path, "A1", 1500, 990, LengthUnit.Pixel); |
|
24 |
} |
|
25 |
workbook.Save(Execl_Path); |
|
26 |
|
|
27 |
} |
|
28 |
} |
|
29 |
} |
ReportApp/ReportApp/Properties/AssemblyInfo.cs | ||
---|---|---|
1 |
using System.Reflection; |
|
2 |
using System.Runtime.CompilerServices; |
|
3 |
using System.Runtime.InteropServices; |
|
4 |
|
|
5 |
// 어셈블리에 대한 일반 정보는 다음 특성 집합을 통해 |
|
6 |
// 제어됩니다. 어셈블리와 관련된 정보를 수정하려면 |
|
7 |
// 이러한 특성 값을 변경하세요. |
|
8 |
[assembly: AssemblyTitle("ReportApp")] |
|
9 |
[assembly: AssemblyDescription("")] |
|
10 |
[assembly: AssemblyConfiguration("")] |
|
11 |
[assembly: AssemblyCompany("")] |
|
12 |
[assembly: AssemblyProduct("ReportApp")] |
|
13 |
[assembly: AssemblyCopyright("Copyright © 2021")] |
|
14 |
[assembly: AssemblyTrademark("")] |
|
15 |
[assembly: AssemblyCulture("")] |
|
16 |
|
|
17 |
// ComVisible을 false로 설정하면 이 어셈블리의 형식이 COM 구성 요소에 |
|
18 |
// 표시되지 않습니다. COM에서 이 어셈블리의 형식에 액세스하려면 |
|
19 |
// 해당 형식에 대해 ComVisible 특성을 true로 설정하세요. |
|
20 |
[assembly: ComVisible(false)] |
|
21 |
|
|
22 |
// 이 프로젝트가 COM에 노출되는 경우 다음 GUID는 typelib의 ID를 나타냅니다. |
|
23 |
[assembly: Guid("cdfd9b99-29fd-4e54-b51d-bef9f275a94f")] |
|
24 |
|
|
25 |
// 어셈블리의 버전 정보는 다음 네 가지 값으로 구성됩니다. |
|
26 |
// |
|
27 |
// 주 버전 |
|
28 |
// 부 버전 |
|
29 |
// 빌드 번호 |
|
30 |
// 수정 버전 |
|
31 |
// |
|
32 |
// 모든 값을 지정하거나 아래와 같이 '*'를 사용하여 빌드 번호 및 수정 번호가 자동으로 |
|
33 |
// 지정되도록 할 수 있습니다. |
|
34 |
// [assembly: AssemblyVersion("1.0.*")] |
|
35 |
[assembly: AssemblyVersion("1.0.0.0")] |
|
36 |
[assembly: AssemblyFileVersion("1.0.0.0")] |
ReportApp/ReportApp/ReportApp.csproj | ||
---|---|---|
1 |
<?xml version="1.0" encoding="utf-8"?> |
|
2 |
<Project ToolsVersion="15.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> |
|
3 |
<Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" /> |
|
4 |
<PropertyGroup> |
|
5 |
<Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration> |
|
6 |
<Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform> |
|
7 |
<ProjectGuid>{CDFD9B99-29FD-4E54-B51D-BEF9F275A94F}</ProjectGuid> |
|
8 |
<OutputType>Exe</OutputType> |
|
9 |
<RootNamespace>ReportApp</RootNamespace> |
|
10 |
<AssemblyName>ReportApp</AssemblyName> |
|
11 |
<TargetFrameworkVersion>v4.6.1</TargetFrameworkVersion> |
|
12 |
<FileAlignment>512</FileAlignment> |
|
13 |
<AutoGenerateBindingRedirects>true</AutoGenerateBindingRedirects> |
|
14 |
<Deterministic>true</Deterministic> |
|
15 |
<TargetFrameworkProfile /> |
|
16 |
</PropertyGroup> |
|
17 |
<PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' "> |
|
18 |
<PlatformTarget>AnyCPU</PlatformTarget> |
|
19 |
<DebugSymbols>true</DebugSymbols> |
|
20 |
<DebugType>full</DebugType> |
|
21 |
<Optimize>false</Optimize> |
|
22 |
<OutputPath>..\..\HYTOS\HYTOS\ReportApp\</OutputPath> |
|
23 |
<DefineConstants>DEBUG;TRACE</DefineConstants> |
|
24 |
<ErrorReport>prompt</ErrorReport> |
|
25 |
<WarningLevel>4</WarningLevel> |
|
26 |
<Prefer32Bit>false</Prefer32Bit> |
|
27 |
</PropertyGroup> |
|
28 |
<PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' "> |
|
29 |
<PlatformTarget>AnyCPU</PlatformTarget> |
|
30 |
<DebugType>pdbonly</DebugType> |
|
31 |
<Optimize>true</Optimize> |
|
32 |
<OutputPath>bin\Release\</OutputPath> |
|
33 |
<DefineConstants>TRACE</DefineConstants> |
|
34 |
<ErrorReport>prompt</ErrorReport> |
|
35 |
<WarningLevel>4</WarningLevel> |
|
36 |
<Prefer32Bit>false</Prefer32Bit> |
|
37 |
</PropertyGroup> |
|
38 |
<PropertyGroup> |
|
39 |
<StartupObject /> |
|
40 |
</PropertyGroup> |
|
41 |
<ItemGroup> |
|
42 |
<Reference Include="BouncyCastle.Crypto, Version=1.8.9.0, Culture=neutral, PublicKeyToken=0e99375e54769942"> |
|
43 |
<HintPath>..\packages\BouncyCastle.1.8.9\lib\BouncyCastle.Crypto.dll</HintPath> |
|
44 |
</Reference> |
|
45 |
<Reference Include="GemBox.Spreadsheet, Version=47.0.0.1207, Culture=neutral, PublicKeyToken=b1b72c69714d4847, processorArchitecture=MSIL"> |
|
46 |
<HintPath>..\packages\GemBox.Spreadsheet.47.0.1207\lib\net35\GemBox.Spreadsheet.dll</HintPath> |
|
47 |
</Reference> |
|
48 |
<Reference Include="PresentationCore" /> |
|
49 |
<Reference Include="PresentationFramework" /> |
|
50 |
<Reference Include="ReachFramework" /> |
|
51 |
<Reference Include="System" /> |
|
52 |
<Reference Include="System.Core" /> |
|
53 |
<Reference Include="System.Drawing" /> |
|
54 |
<Reference Include="System.Printing" /> |
|
55 |
<Reference Include="System.Security" /> |
|
56 |
<Reference Include="System.Windows.Forms" /> |
|
57 |
<Reference Include="System.Xml.Linq" /> |
|
58 |
<Reference Include="System.Data.DataSetExtensions" /> |
|
59 |
<Reference Include="Microsoft.CSharp" /> |
|
60 |
<Reference Include="System.Data" /> |
|
61 |
<Reference Include="System.Net.Http" /> |
|
62 |
<Reference Include="System.Xml" /> |
|
63 |
<Reference Include="WindowsBase" /> |
|
64 |
</ItemGroup> |
|
65 |
<ItemGroup> |
|
66 |
<Compile Include="Program.cs" /> |
|
67 |
<Compile Include="Properties\AssemblyInfo.cs" /> |
|
68 |
</ItemGroup> |
|
69 |
<ItemGroup> |
|
70 |
<None Include="App.config" /> |
|
71 |
<None Include="packages.config" /> |
|
72 |
</ItemGroup> |
|
73 |
<Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" /> |
|
74 |
</Project> |
ReportApp/ReportApp/packages.config | ||
---|---|---|
1 |
<?xml version="1.0" encoding="utf-8"?> |
|
2 |
<packages> |
|
3 |
<package id="BouncyCastle" version="1.8.9" targetFramework="net461" /> |
|
4 |
<package id="GemBox.Spreadsheet" version="47.0.1207" targetFramework="net461" /> |
|
5 |
</packages> |
내보내기 Unified diff