alizafar82 / excellibrary Goto Github PK
View Code? Open in Web Editor NEWAutomatically exported from code.google.com/p/excellibrary
Automatically exported from code.google.com/p/excellibrary
What steps will reproduce the problem?
1. Make a xls file read only
2. Call Load on file
What is the expected output? What do you see instead?
Allow reads from xls file. Exception was thrown, access denied to file
What version of the product are you using? On what operating system?
Latest. XP
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 14 Aug 2009 at 12:23
What steps will reproduce the problem?
1. Loading the file you saved for issue 18
2.
3.
What is the expected output? What do you see instead?
Exception
What version of the product are you using? On what operating system?
ExcelLibrary_20090219 with the r41 fixes
Please provide any additional information below.
Thank you for the fix to the prior issue I posted. It can write large
spreadsheets. Unfortunately, it can no longer read any spreadsheets. To
reproduce the error simply try to load the spreadsheet you are now able to
save in the example I sent you.
Original issue reported on code.google.com by [email protected]
on 13 Mar 2009 at 4:13
What steps will reproduce the problem?
1. Try to open big Excel file (about 300 Mb)
It seems problem is in "int" type insted of "uint" in position and
counters.
Original issue reported on code.google.com by [email protected]
on 26 Apr 2009 at 7:07
While I was writing test case for DataSetHelper, I noticed that
Workbook.Save() may create malformed Excel workbook under some special
circumstances.
Workbook.Save() wrote to file without any warning. However, when open the
same file using Workbook.Open(), I get System.IO.EndOfStreamException. If I
try to open the file using Excel, I also get "Unable to read file." error.
I have created a test case to demo the issue, SimpleTest.WriteCellTest1(),
please have a look.
Original issue reported on code.google.com by jetcat
on 9 Feb 2009 at 2:16
What steps will reproduce the problem?
1. Opening the attached file using workbook.open().
2.
3.
What is the expected output? What do you see instead?
The code throws an exception in the Record.ReadString() method. So there
is no output.
What version of the product are you using? On what operating system?
I don't know what version of the product I'm using. I downloaded my
current version on 2-13-2009 from
http://www.codeproject.com/KB/office/ExcelReader.aspx.
The attached files were created using Excel 2003 on a Win XP system.
Please provide any additional information below.
While attempting to open a file using your product, I sometimes get an
error. The error occurs in the Record.cs file, in the ReadString()
method. Specifically, the error occurs when the code then reads an
incorrectly large value for the variable "stringlength" (representing the
length of the string to read), or the variable "size," (representing the
length of the Asian phonetic settings). This large value is typically
greater than 10,000 or even 100,000, and creates an exception because that
many bytes cannot be read into an array.
Through testing, I've found that the error seems to occur when your code
switches to a continued record using SwitchToContinuedRecord() because the
end of the current stream has been reached. The switch to a continued
record I'm referring to occurs on line 3 of the ReadString() method. I've
been unable to determine the cause of the error. Maybe its just because
the file is from Excel 2003. Or maybe its because about 30-35 records end
up in the "default" case in the Record.Read() method.
Original issue reported on code.google.com by [email protected]
on 18 Feb 2009 at 1:48
Attachments:
What steps will reproduce the problem?
1. use this code on a web project
private void Calculate2()
{
//Locate an xcel file in your server and map that filepath
string filePath = "~\\Files\\myXcl.xls" //just for example
string serverPath = MapPath(filePath);
Workbook workbook = Workbook.Load(serverPath); //exception thrown
//Assert.AreEqual(1, workbook.Worksheets.Count);
Worksheet worksheet = workbook.Worksheets[0];
////Assert.AreEqual("Test1", worksheet.Name);
//Assert.AreEqual(100, worksheet.Cells[0, 1].Value);
//Assert.AreEqual("Test String", worksheet.Cells[2, 0].Value);
}
2.
3.
What is the expected output? What do you see instead?
I expect the library to succesfully open this file, I need to find some
cells info Instead I get this exception: Unable to read beyond the end of
the stream.
I try using a FileStream and open the file in Read Mode but then it said
that it can not fiond the end of the stream.
What version of the product are you using? On what operating system?
the one included un the release folder of the solution in this file :
ExcelLibrary_20090331.zip Archived project code on 2009-03-31.
Please provide any additional information below.
I have all the permissions in the folder.
Original issue reported on code.google.com by [email protected]
on 2 May 2009 at 12:45
What steps will reproduce the problem?
Workbook workbook = new Workbook();
Worksheet worksheet = new Worksheet("Test");
worksheet.Cells[0, 0] = new Cell(101u);
workbook.Worksheets.Add(worksheet);
workbook.Save(tempFile);
What is the expected output? What do you see instead?
System.Exception: Invalid cell value.
Please provide any additional information below.
Patch included
Original issue reported on code.google.com by [email protected]
on 29 May 2009 at 11:13
Attachments:
[deleted issue]
I'm trying to set row height
worksheet.Cells.Rows[19].Height = 500;
but it doesn't work
Original issue reported on code.google.com by [email protected]
on 28 May 2009 at 8:57
What steps will reproduce the problem?
1.This product does not display the dates in the actual formate.
2.
3.
What is the expected output? What do you see instead?
My excel file having '4/22/2009' but this product will displaying
as '39835'. This product does not display in the actual formate
What version of the product are you using? On what operating system?
Latest version of product,excel 2003 on Windows XP OS
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 12 May 2009 at 11:58
Kindly let us know, as to when excel 2007 documents will be supported.
Original issue reported on code.google.com by [email protected]
on 5 Oct 2009 at 8:36
Can you sign the assembly?
Original issue reported on code.google.com by [email protected]
on 31 Jul 2009 at 10:15
Classes in SpreadSheet logical layer should not reference classes in
storage layer.
Original issue reported on code.google.com by China.LiuJunFeng
on 13 Feb 2009 at 6:41
What steps will reproduce the problem?
1. Open an excel file that has formatted text using CompoundDocument.Open
2. Save it with a different name. All the format was lost
I expected that the format were kept.
The same happened when I set a bold font programmatically and then saved
the file. Format is not taken into account
The version of the product is of 03/31/2009
Original issue reported on code.google.com by [email protected]
on 28 Jul 2009 at 9:29
I have a problem with attached excel document. ExcelReader cannot read this
document.
can it be fixed or this is big work?
Original issue reported on code.google.com by [email protected]
on 27 Jun 2009 at 8:45
Attachments:
What steps will reproduce the problem?
1. Add a number with more than 1 decimal place (using code: .Cells(0, 0) =
New ExcelLibrary.SpreadSheet.Cell(1.2345)
2. Save spreadsheet
3. Number shows as 1.23 (rounds up or down)
What is the expected output? What do you see instead?
1.2345
What version of the product are you using? On what operating system?
Latest dll, VB2005, XP
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 4 Aug 2009 at 3:53
Hi!
In my code i used:
planilha.Cells[i + 4, 0] = new Cell(intervalos[i].dtTime);
planilha.Cells[i + 4, 0].DateTimeValue = intervalos[i].dtTime;
planilha.Cells[i + 4, 0].FormatString = "h:mm:ss";
I expected to set a DateTime to the property DateTimeValue, to in next line
format to a time.
Error: SharedResource was NULL !
Where: Cell.cs
Line: 96
Checkout SVN: 12/02/2009 - At: 10:00 AM
part of code:
set
{
double days = SharedResource.EncodeDateTime(value);
this._value = days;
}
Original issue reported on code.google.com by [email protected]
on 12 Feb 2009 at 12:48
The LastColIndex/ LastRowIndex are reversed. Here's the correct code:
DatasetHelper.PopulateDataTable:
..
// Extract columns
for (int i = 0; i <= Cells.LastColIndex; i++)
dt.Columns.Add(Cells[0, i].StringValue, typeof(String));
// Extract data
for (int currentRowIndex = 1; currentRowIndex <=
Cells.LastRowIndex; currentRowIndex++)
{
..
Original issue reported on code.google.com by [email protected]
on 11 Feb 2009 at 9:33
Since we move all existing code into this new project, we should consider
to change existing namespace - QiHe into ExcelLibrary. This is more
consistent and also less confusing for the users of this library.
Original issue reported on code.google.com by jetcat
on 27 Jan 2009 at 12:56
Hi,
when I try to print the .xls file created got an error from excel (2002
and 2007 running on winXP); it's in italian, a rough tanslation could
be "I can't find any information to print". The problem disappear if I
enter any value in a free cell.
With OpenOffice the error doesn't appear and the printing is normal.
Thank you.
Stefano
Original issue reported on code.google.com by [email protected]
on 4 Mar 2009 at 9:12
Attachments:
What steps will reproduce the problem?
1.Create a new xls with de excelLibrary contains test cells with style
defined by code:
sheet.Cells[0, 0] = new Cell("Test");
sheet.Cells[0, 0].Style = new CellStyle();
sheet.Cells[0, 0].Style.BackColor = System.Drawing.Color.Green;
2.Save sheet
What is the expected output? What do you see instead?
Cell[0,0] ="Test" with green background color. And...nothing, only the
value "Test" was printed.
What version of the product are you using? On what operating system?
tried two versions: ExcelLibrary_20090219 and ExcelLibrary_20090331
Original issue reported on code.google.com by [email protected]
on 15 Sep 2009 at 4:27
- Add license information into all source code
- Add license terms into repository
Original issue reported on code.google.com by jetcat
on 27 Jan 2009 at 12:52
Cannot open one xls file in OfficeDoc. Exception in this source code of
class QiHe.Office.Excel.MsofbtDgg:
namespace QiHe.Office.Excel
{
public partial class MsofbtDgg : EscherRecord
{
// This collection never used
Dictionary<int, int> GroupIdClusters = new Dictionary<int, int>();
public override void Decode()
{
MemoryStream stream = new MemoryStream(Data);
BinaryReader reader = new BinaryReader(stream);
MaxShapeID = reader.ReadInt32();
NumIDClusters = reader.ReadInt32();
NumSavedShapes = reader.ReadInt32();
NumSavedDrawings = reader.ReadInt32();
IDClusters = new List<long>();
while (stream.Position < stream.Length)
{
//IDClusters.Add(reader.ReadInt64());
int drawingGroupId = reader.ReadInt32();
int numShapeIdsUsed = reader.ReadInt32();
// In this line i has a Exception (Double keys)
GroupIdClusters.Add(drawingGroupId, numShapeIdsUsed);
}
}
}
}
I remove line GroupIdClusters.Add(drawingGroupId, numShapeIdsUsed); and all
be fine.
Original issue reported on code.google.com by [email protected]
on 26 Mar 2009 at 7:48
Does your ExcelLibrary now allow to read from office 2007 file format. I'm
currently use the version that you post on CodeProject before february
2009 and that version still not allow to read with .xlxs file format. Is
there a way for me
Thank
Original issue reported on code.google.com by [email protected]
on 24 Aug 2009 at 5:40
Hi Guys,
That last correction I had suggest don't quite work for me, so I Resolve
to Add just 2 new Types on cell Format to make it easy...
If you want to you it, fill free to do so:
After yours "public static readonly CellFormat Date = new
CellFormat(CellFormatType.Date, @"YYYY\-MM\-DD");"
I write:
/// <summary>
/// Format the DateTime with: "HH:mm:ss" e.g: 14:45:00
/// </summary>
/// <example>Format the DateTime with: "HH:mm:ss" e.g:
14:45:00</example>
public static readonly CellFormat Time = new
CellFormat(CellFormatType.Time, "HH:mm:ss");
/// <summary>
/// Format the number with: "#,###.00000" e.g: 100.12345
/// </summary>
/// <example>Format the number with: "#,###.00000" e.g:
100.12345</example>
public static readonly CellFormat Engineer = new
CellFormat(CellFormatType.Scientific, "#,###.00000");
Original issue reported on code.google.com by [email protected]
on 17 Feb 2009 at 12:28
Attachments:
What steps will reproduce the problem?
1. Writing any excel file requiring over 109 secid's
2.
3.
What is the expected output? What do you see instead?
valid excel file. Exception.
What version of the product are you using? On what operating system?
ExcelLibrary_20090219
Please provide any additional information below.
In GetSATSectorID should be checking for SATSectorIndex == NumberofSEcIDs -
1
In AllocateSATSector it appears to be confusing sectors and sectorID's
i.e. for each new sector "SecIDCapacity" new sectorIS's should be
available (not one more as would be the increment for number of new
sectors).
Original issue reported on code.google.com by [email protected]
on 10 Mar 2009 at 4:51
Is it possible to implement such thing?
example:
input: two merged cells
------------------
CellData |
------------------
output
--------------------
CellData | CellData |
--------------------
Original issue reported on code.google.com by [email protected]
on 27 Aug 2009 at 1:15
What steps will reproduce the problem?
1.create a workbook which contains cells with more than 10 000 chars
2. save as compound document .xls
What is the expected output? What do you see instead?
when you try to open it with excel 2007 : corrupted file
What version of the product are you using? On what operating system?
windows.excel 2007
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 3 Sep 2009 at 5:27
Attachments:
What steps will reproduce the problem?
1. Start MS Access 20007
2. Create new Table with some fields
3. Export table to MS Excel 97/2003
4. Open Excel file using the Webform sample
What is the expected output? What do you see instead?
No Output, only an exception
What version of the product are you using? On what operating system?
Several different OS
I attached a sample XLS file, that will cause the exception.
here's the stackflow:
> ExcelLibrary.dll!ExcelLibrary.BinaryFileFormat.BOF.Decode() Line 40
C#
ExcelLibrary.dll!ExcelLibrary.BinaryFileFormat.WorkbookDecoder.ReadRecords(
System.IO.Stream stream = {System.IO.MemoryStream}, out
ExcelLibrary.BinaryFileFormat.MSODRAWINGGROUP drawingGroup = null) Line 37
+ 0x8 bytes C#
ExcelLibrary.dll!ExcelLibrary.BinaryFileFormat.WorkbookDecoder.Decode(Syste
m.IO.Stream stream = {System.IO.MemoryStream}) Line 17 + 0x11 bytes C#
ExcelLibrary.WinForm.exe!ExcelLibrary.WinForm.Form1.LoadExcelSheets() Line
130 + 0x29 bytes C#
ExcelLibrary.WinForm.exe!ExcelLibrary.WinForm.Form1.tabControl1_Selected(ob
ject sender = {System.Windows.Forms.TabControl, TabPages.Count: 3,
TabPages[0]: TabPage: {HexView}}, System.Windows.Forms.TabControlEventArgs
e = {System.Windows.Forms.TabControlEventArgs}) Line 117 + 0x8 bytes C#
...
Original issue reported on code.google.com by [email protected]
on 25 Mar 2009 at 11:49
Attachments:
What steps will reproduce the problem?
1.Loading a previously created excel workbook.
2.Pulling data from database into workbook.
3.Saving workbook to same file name or new file name results in format loss.
What is the expected output? What do you see instead?
I have a header row that is formatted through excel and after saving the
file through code it looses its formats
What version of the product are you using? On what operating system?
Windows XP 3\31\2009
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 7 Apr 2009 at 3:53
What steps will reproduce the problem?
1. create a new file or open one
2. make changes
3. hit the save button
4. the changes aren't saved
What is the expected output? What do you see instead?
i wish the data was saved, the data isn't saved
What version of the product are you using? On what operating system?
latest
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 16 Jun 2009 at 10:39
What steps will reproduce the problem?
1. var book = Workbook.Load(filename)
2.
3.
What is the expected output? What do you see instead?
Throws an ArgumentException "Stream was not writable" at:
internal CompoundDocument(Stream stream, FileHeader header)
{
...
this.Writer = new BinaryWriter(this.FileStorage,
Encoding.Unicode);
...
}
What version of the product are you using? On what operating system?
ExcelLibrary_20090331.zip, Windows XP
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 29 Apr 2009 at 9:07
What steps will reproduce the problem?
1. Create a new cell or access a cell that already exists
2. Try to set the background color of the "Cell" object
What is the expected output? What do you see instead?
We should be able to write:
myCell.BackColor = System.Drawing.Color.Yellow;
Instead, the property is read-only.
What version of the product are you using? On what operating system?
I am using the DLL available for download
ExcelLibrary.dll Compiled on 2009-02-12.
Original issue reported on code.google.com by [email protected]
on 5 Aug 2009 at 7:01
Add support for encoding images into workbook
Original issue reported on code.google.com by jetcat
on 29 Jan 2009 at 12:51
What steps will reproduce the problem?
1. Populate a cell with a large value (9,999,999 for example)
2. Try to save Workbook
What is the expected output? What do you see instead?
Error Type: System.OverflowException
Error Source: mscorlib
Error Message: Value was either too large or too small for a UInt32.
Stack Trace: at System.Decimal.ToUInt32(Decimal d)
at System.Decimal.op_Explicit(Decimal value)
at ExcelLibrary.BinaryFileFormat.WorkSheetEncoder.EncodeCell(Cell cell,
SharedResource sharedResource)
at ExcelLibrary.BinaryFileFormat.WorkSheetEncoder.Encode(Worksheet
worksheet, SharedResource sharedResource)
at ExcelLibrary.BinaryFileFormat.WorkbookEncoder.EncodeWorkbook
(Workbook workbook)
at ExcelLibrary.BinaryFileFormat.WorkbookEncoder.Encode(Workbook
workbook, Stream stream)
at ExcelLibrary.SpreadSheet.Workbook.Save(String file)
What version of the product are you using? On what operating system?
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 30 Jun 2009 at 12:00
I am using the ExcelLibrary Dll into my class library to read excel
documents. One of the methods that I call and which in turn has calls to
the dll's methods and objects, fails on the step of creation of Worksheet
object.
When I comment the Worksheet declaration statement the code works fine.
Original issue reported on code.google.com by [email protected]
on 6 Apr 2009 at 10:00
I am working on a windows application (VB.net) which will deployed in a
server that doesn't have OFFICE installed. i am using excellibrary.dll to
export the data in to excel.
Does it require OFFICE Instalation in the server or it doesn't?
Regards, Priya
Original issue reported on code.google.com by [email protected]
on 16 Aug 2009 at 8:43
hi,
i would suggest adding the following to the Cell.cs:
public override string ToString()
{
return StringValue;
}
because i think it would be more usefull than default ToString which
returns ExcelLibrary.SpreadSheet.Cell
Original issue reported on code.google.com by [email protected]
on 16 Apr 2009 at 11:07
What steps will reproduce the problem?
1.
2.
3.
What is the expected output? What do you see instead?
What version of the product are you using? On what operating system?
Please provide any additional information below.
The current version of the library does not seem to store Font records.
Am I mistaken?
It does not seem difficult to store font records and make them accessible
through the workbook. I have modified the files below in the following
ways to account for font records:
1. SharedResource - added Fonts() list
2. WorkbookDecoder.decodeRecords - adds FONT records to the Fonts() list
in SharedResource
3. Added RichTextFormat class to SubRecords folder.
4. SST (extended version) - added variable to hold all "RichTextFormat"
data for all strings in SST
5. SST (extended version) - modified decode() to call readStringRTF() read
the RichText info into a separate variable
6. Record - added ReadStringRTF(), which reads and stores the "rich text
format" data associated with a string
7. Record - added decodeRichTextFormatting()
I've also attached my revised Worksheet file. I am interested in
retrieving the font record for a given character in a cell. I implemented
a binary search through the rich-text formatting runs (stored as in the
attached files), although I did this using an old version of your project,
so it does not compile properly now.
Anyway, I hope you implement the font records in a forthcoming update. It
would be really helpful.
Original issue reported on code.google.com by [email protected]
on 19 Feb 2009 at 2:22
Attachments:
Steps to reproduce the problem:
1. create a XLS
2. Open it with M$ 2003 SP3
The "index to active (displayed) worksheet" WINDOW1 Offset 10 Size 2
doesn't work for Office 2003 SP3
(for example: window.ActiveWorksheet = 0;) I can see the first worksheet
(of 2 for example) but the name of the worksheet isn't bold, the worksheet
isn't activated. You can try to print the sheet, then it will tell you that
there aint any data to print at the active sheet.
I think its a M$ Office BIFF8 problem, because its shows ok with OpenOffice
3.x. The right worksheet is active and the worksheet name is bold, i can
print it.
Can you help? What can I do, to fix it?
System: Windows XP 64bit latest updates, english
Office: M$ Office 2003 (SP3) Professional, german
and your latest great library!
Original issue reported on code.google.com by [email protected]
on 13 May 2009 at 1:30
What steps will reproduce the problem?
1. Workbook workbook = new Workbook();
Worksheet worksheet = new Worksheet("First Sheet");
worksheet.Cells[0, 1] = new Cell("teste");
worksheet.Cells.ColumnWidth[0, 1] = 3000;
worksheet.Cells[0, 1].Style = new CellStyle();
worksheet.Cells[0, 1].Style.BackColor = System.Drawing.Color.Gold;
workbook.Worksheets.Add(worksheet);
workbook.Save(file);
2.
3.
What is the expected output? What do you see instead?
I expected to change the cell background color, but it doesn't work.
What version of the product are you using? On what operating system?
ExcelLibrary_20090331.zip. There's another issue that says that in a new
version (up from 12-02-2009) this issue is solved, I tried in 31-03-2009
version, but it's not working.
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 29 Sep 2009 at 5:07
Please modify the Decode method of DBCELL as it is causing error while
encoding back.
MemoryStream stream = new MemoryStream(Data);
BinaryReader reader = new BinaryReader(stream);
this.FirstRowOffset = reader.ReadUInt32();
//
int count = (Size - 4) / 2;
FirstCellOffsets = new List<UInt16>();
for (int i = 0; i < count; i++)
{
UInt16 fco = reader.ReadUInt16();
FirstCellOffsets.Add(fco);
}
Original issue reported on code.google.com by [email protected]
on 15 Sep 2009 at 3:21
May need to add a calculation engine
Original issue reported on code.google.com by jetcat
on 26 Jan 2009 at 11:37
Hi!
I'm thinking in use your excellibrary into my program, but for this I will
have to made a little modifications, to transform this great development
into a dll version...
I can do it, for you, your do you prefer I just do for my propose only?
Thanks for written this very nice work.
Original issue reported on code.google.com by [email protected]
on 11 Feb 2009 at 7:15
Hi all,
first of all thank you for your good library, I've been using for only a
few days the dll compiled on 2009-02-12 in a VB.net project running on
winXP. I'm not a good programmer so maybe it's my fault and I'm missing
some steps, but I experience a problem with date. My code get a date value
from a DataView and put it in a cell, but when I open the xls file I find
1 day added, i.e. february 25 instead of february 24, note that if I stop
the code during debugging and read the cell value it is the right one.
No problems with other cells containing decimal or string values.
This is an extract of the code:
........
Dim MyDataView As DataView = New DataView MyDataset.Tables(MyTable))
dim MyWorksheet As Worksheet
....the dataview is rowfiltered.........
Dim MyDate As Date = MyDataView.Item(0).Item("date")
MyWorksheet.Cells(Riga, 0) = New Cell(MyDate, "DD\-MM\-YY")
...........
Another question: is it possible to change font color, backcolor, border
or alignement in a cell?
Many thanks.
Stefano
Original issue reported on code.google.com by [email protected]
on 24 Feb 2009 at 12:43
This problem has already been mentioned, but here is some more detail.
What steps will reproduce the problem?
1. Reading a large file. (For me large is from around 10mb)
2.
3.
What is the expected output? What do you see instead?
I have encountered this problem at two different stages (not sure what it
depends on, possibly:
1.
internal static Int32[] ReadArrayOfInt32(BinaryReader reader, int count)
{
Int32[] data = new Int32[count];
for (int i = 0; i < data.Length; i++)
{
data[i] = reader.ReadInt32(); //throws EndOfStreamException
//reader Length is 23164416
//reader Position is 2106864640 (I suppose Length is
supposed to be greater than Position?)
}
return data;
}
2.
internal int[] ReadSectorDataAsIntegers(int SID)
{
int offset = GetSectorOffset(SID);
Reader.BaseStream.Position = offset; //throws
ArgumentOutOfRangeException (GetSectorOffest returns large negative int)
return ReadArrayOfInt32(Reader, SectorSize / 4);
}
What version of the product are you using? On what operating system?
ExcelLibrary_20090331.zip
Please provide any additional information below.
The excel files I am using have lots of formulas and macros
Original issue reported on code.google.com by [email protected]
on 7 May 2009 at 7:08
it fails when I create two worksheets and save (workbook.save)
it's no error when add multiple sheets into workbook but failed when save.
is it possible to save an excel more than a sheet? thanks
Original issue reported on code.google.com by [email protected]
on 27 Apr 2009 at 10:48
I feel that ExcelLibrary.Office.Excel is also not a good name.
My propose is:
Use the following namespace for logical layer:
ExcelLibrary.SpreadSheet
Use the following namespaces for storage layer:
ExcelLibrary.BinaryFileFormat
ExcelLibrary.BinaryDrawingFormat
ExcelLibrary.CompoundDocumentFormat
And change the project directory structure correspondingly.
Original issue reported on code.google.com by China.LiuJunFeng
on 13 Feb 2009 at 3:26
What steps will reproduce the problem?
1. Create a spreadsheet using excellibrary
2. Open the spreadsheet in Excel
3. Try to print the spreadsheet
What is the expected output? What do you see instead?
Should print, instead get message 'Excel could not find anything to print'
If you copy the data to a new spreadsheet then it prints fine.
What version of the product are you using? On what operating system?
VB2005,XP, Excel 2003
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 6 Aug 2009 at 9:16
We should analyse the second row to find the correct type and use that type
for the DataColumn.. Currently i only changed to add the DateTimeValue
instead of the Value.
for (int currentRowIndex = 1; currentRowIndex <= Cells.LastRowIndex;
currentRowIndex++)
{
DataRow dr = dt.NewRow();
object value = null;
for (int currentColumnIndex = 0; currentColumnIndex <=
Cells.LastColIndex; currentColumnIndex++) {
if (Cells[currentRowIndex, currentColumnIndex].IsEmpty)
dr[currentColumnIndex] = Cells[currentRowIndex,
currentColumnIndex];
else {
switch (Cells[currentRowIndex,
currentColumnIndex].Format.FormatType)
{
case CellFormatType.Date:
case CellFormatType.Time:
case CellFormatType.DateTime:
value = Cells[currentRowIndex,
currentColumnIndex].DateTimeValue;
break;
default:
value = Cells[currentRowIndex,
currentColumnIndex].Value;
break;
}
dr[currentColumnIndex] = value;
}
}
dt.Rows.Add(dr);
}
Original issue reported on code.google.com by [email protected]
on 11 Feb 2009 at 10:01
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.