-
Jul 29th, 2021, 10:58 PM
#1
Thread Starter
PowerPoster
what about Spread32?it's can open *.xls file like excel
what about Spread32?it's can open *.xls file like excel
.NET, JavaScript and COM Spreadsheet Solutions | GrapeCity Spread
https://www.grapecity.com/spread
Last edited by xiaoyao; Jul 30th, 2021 at 07:57 PM.
-
Jul 30th, 2021, 02:17 AM
#2
Re: what about Spread32?it's can open *.xls file like excel
What do you want to know?
Is it about a grid control?
Or is it about reading a xls file? XLS files are in BIFF format.
Search for Excel BIFF reader
-
Jul 30th, 2021, 04:28 AM
#3
Thread Starter
PowerPoster
Re: what about Spread32?it's can open *.xls file like excel
read excel file from xls file,xlsx file,and show it
find a control like excel,can read xls file ,and edit,and save to new xls file
-
Jul 30th, 2021, 05:31 AM
#4
Re: what about Spread32?it's can open *.xls file like excel
The vsFlexgrid can read and save single sheet xls files (biff 5 format)
-
Jul 30th, 2021, 09:11 AM
#5
Thread Starter
PowerPoster
Re: what about Spread32?it's can open *.xls file like excel
Originally Posted by Arnoutdv
The vsFlexgrid can read and save single sheet xls files (biff 5 format)
maybe it's only for show data like csv?
i want show excel sheet with cell back color,Merge cells, even insert pictures, the cells must also support formulas
-
Jul 30th, 2021, 09:16 AM
#6
Re: what about Spread32?it's can open *.xls file like excel
Is this like one of those freelance job offers: Need facebook clone for $500 in 3 months?
cheers,
</wqw>
-
Jul 30th, 2021, 09:37 AM
#7
Re: what about Spread32?it's can open *.xls file like excel
Originally Posted by xiaoyao
maybe it's only for show data like csv?
i want show excel sheet with cell back color,Merge cells, even insert pictures, the cells must also support formulas
That’s Excel…
-
Jul 30th, 2021, 07:59 PM
#8
Thread Starter
PowerPoster
Re: what about Spread32?it's can open *.xls file like excel
Originally Posted by Arnoutdv
That’s Excel…
.NET, JavaScript and COM Spreadsheet Solutions | GrapeCity Spread
https://www.grapecity.com/spread
Spread.NET
Components and designers for WinForms, ASP.NET, WPF, and WinRT
SpreadJS
Dependency-free JavaScript spreadsheet components for web applications
Spread COM
Spread's classic COM spreadsheet component for use in Visual Studio 6
in fact ,This control implements all these functions, the web version of EXCEL, supports formulas, and supports charts.
Support js, vb.net, c#, and COM object mode VB6, VBA, DELPHI support, etc.
-
Jul 30th, 2021, 08:02 PM
#9
Thread Starter
PowerPoster
Re: what about Spread32?it's can open *.xls file like excel
wps by china corp,it's same like excel,This software implements all these functions. I heard that it also has a .NET SDK. If it can also be made into a small control, it may be very good to directly display a simpler EXCEL table.
The early doc, xls and other formats are exclusive to Microsoft, and there is no open source, and of course other software is not compatible. When the system was still dos, Kingsoft wps had an absolute advantage in China. In order to open the Chinese market, MS office signed a two-way compatibility agreement with wps, that is, ms office can read wps format, and wps can also read ms office format. Documents, mutual authorization
Because many organizations and government departments use the MS OFFICE format to save documents, but they cannot read these files at all without using ms office, and they cannot connect with their own unique office system, so Microsoft is forced to open up under the antitrust situation. Office format, as well as competitors from the Linux system open office, so Microsoft was forced to open the Office format. (Note: MS office format opening is forced)
Last edited by xiaoyao; Jul 30th, 2021 at 08:08 PM.
-
Jul 31st, 2021, 01:33 AM
#10
Re: what about Spread32?it's can open *.xls file like excel
Then what’s your question??
-
Jul 31st, 2021, 02:39 AM
#11
Thread Starter
PowerPoster
Re: what about Spread32?it's can open *.xls file like excel
There are too few controls that can be closer to the EXCEL function. The only powerful one is charged, and the price is not cheap. Perhaps the easiest way is to directly use the EXCEL object to open the EXCEL table, this is the most perfect function, and the price is cheaper than the control
-
Jul 31st, 2021, 04:02 AM
#12
Re: what about Spread32?it's can open *.xls file like excel
Originally Posted by xiaoyao
There are too few controls that can be closer to the EXCEL function. The only powerful one is charged, and the price is not cheap. Perhaps the easiest way is to directly use the EXCEL object to open the EXCEL table, this is the most perfect function, and the price is cheaper than the control
There is one fellow countryman of yours hiding in these forums that claims his spread control is as powerful as the commercial implementation and/or Excel (no word about WPS) but his past history with sharing code is non-existent so there is no hope there IMO.
cheers,
</wqw>
-
Jul 31st, 2021, 07:42 PM
#13
Re: what about Spread32?it's can open *.xls file like excel
Originally Posted by wqweto
There is one fellow countryman of yours hiding in these forums that claims his spread control is as powerful as the commercial implementation and/or Excel (no word about WPS) but his past history with sharing code is non-existent so there is no hope there IMO.
cheers,
</wqw>
In my opinion, different people have different divisions of labor. Some people are responsible for imparting some small skills and small knowledge points, and some are responsible for completing some creative works. They are all contributing to this forum. Isn't it?
If I spend all my time on those trivial user-controls, I will never be able to accomplish more important things.
If you can provide people with more valuable products, I suggest you stop wasting time on small things.
Spread seems to be a mountain you can never cross.
Last edited by SearchingDataOnly; Jul 31st, 2021 at 07:50 PM.
-
Jul 31st, 2021, 10:21 PM
#14
Thread Starter
PowerPoster
Re: what about Spread32?it's can open *.xls file like excel
This person has also developed a large number of controls, and I would like to praise him greatly. VB6 may live another 10-20 years
Project App.path from inside UC in OCX? [Solved]-VBForums
https://www.vbforums.com/showthread....-in-OCX-Solved
{ VB6 - AddIn Document Map (thumbnail code navigation) } { VB6 - AddIn IDE Codefolding }
{ VB6 - AddIn Comment/Code Display + Highlight + Extra Hotkeys } { VB6 - sButton (multipurpose control) }
{ VB6 - Smooth Scrollbar Control } { VB6 - ScrollAdd (add scrolling to current forms and containers) }
{ VB6 - UcFormResizerLimiter } { VB6 - Virtual Pet Roach }
-
Aug 1st, 2021, 08:19 AM
#15
Re: what about Spread32?it's can open *.xls file like excel
I see a ton of crap being dumped into the CodeBank lately that was already there. Usually "the serial numbers" are scratched out, and sometimes there are trivial changes. Copying other people's work seems to be a national sport.
-
Aug 1st, 2021, 09:25 AM
#16
Re: what about Spread32?it's can open *.xls file like excel
I removed a series of personal attacks/bickering. I think everybody has their opinions, and they are probably known to one another.
Still, that leaves an awful lot of posts, and I STILL have no idea whether or not there is a question in this whole thread. Or, perhaps there IS a question, but the OP also provided the answer: If you want a tool as powerful and complete as Excel for showing and working with Excel spreadsheets, the answer is clearly: Excel.
My usual boring signature: Nothing
-
Aug 1st, 2021, 09:33 AM
#17
Re: what about Spread32?it's can open *.xls file like excel
Last edited by SearchingDataOnly; Aug 1st, 2021 at 11:20 AM.
-
Aug 2nd, 2021, 03:32 AM
#18
Thread Starter
PowerPoster
Re: what about Spread32?it's can open *.xls file like excel
I just want to use it to load a simple EXCEL form, XLS format is also available, make appropriate modifications, and then save. There are still many controls available, but I don't know. The purpose of posting is to let everyone talk about some of the controls they have used and share their experience.
Spread32 is charged, I wonder if there is a free version.
EXCEL is not opened directly, after opening SETPARENT to the software, as a control to use.
-
Aug 3rd, 2021, 05:57 AM
#19
Re: what about Spread32?it's can open *.xls file like excel
you can use an ole control to open excel directly within the control
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
-
Aug 3rd, 2021, 07:04 AM
#20
Re: what about Spread32?it's can open *.xls file like excel
How about using SHELL to open the Excel file directly? Make changes. Save. Simple.
Sam I am (as well as Confused at times).
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|