/*
31 characters
Microsoft Excel does not allow worksheet name longer than 31 characters.
*/
/*
Excel Worksheet Naming Rules and Tips
► A worksheet name cannot cannot exceed 31 characters. ► A worksheet name cannot be left blank. ► A worksheet cannot be named history in either lower or uppercase.
*/
using C1.C1Excel;
namespace Problem
{
class Program
{
public static void Main(string[] args)
{
Problem_2021_10_15 nm = new Problem_2021_10_15();
nm.running();
}
}
class Problem_2021_10_15
{
public void running()
{
C1XLBook book = new C1XLBook();
XLSheet sheet = book.Sheets[0];
sheet.Name="1234567890123456789012345678901";
//Microsoft Excel does not allow worksheet name longer than 31 characters.
XLStyle style = new XLStyle();
style.AlignHorz = XLAlignHorzEnum.Center;
XLCell cell = sheet[1,0];
cell.Value="1234567890123456789012345678901";
//Microsoft Excel does not allow worksheet name longer than 31 characters.
}
}
}
'c# 언어' 카테고리의 다른 글
C1 배포 & Deploy(Micro.Visual.Studio.C#) (0) | 2021.10.20 |
---|---|
C1.C1Excel.4.5.2 Assembly / C1.C1Excel Namespace (0) | 2021.10.20 |
C# - 엑셀 COM 레퍼런스 추가하기 (0) | 2021.10.20 |
문제 풀이 : Lv1. 숫자 문자열과 영단어 (0) | 2021.10.18 |
Console 3*3 tris game source (0) | 2021.10.05 |