BIFF8 Excel Reader

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Framework
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Data Form Wizard: value cannot be null, parameter name: type PROBLEM: I saw previous posts on the issue where you try to use the Data Form Wizard and you get the error: Data Form Wizard: value cannot be null, parameter name: type I also saw various solutions. None of which worked for me. I am using Version 2003 of Visual Studio .NET. SOLUTION: You can't name your Dataset the same as your table name that will be in the dataset or you will get this error. For example, I called my dataset "Agent" and my database table name was also "Agent". This choked. When I changed the dataset name to Agent01 and selected Agent table, it worked correctly. FYI. Tag: BIFF8 Excel Reader Tag: 93855
  - 2
    - Cross AppDomain Communication, Scripting Howdy All, I am having difficulty with two-way communication across AppDomains in an attempt to dynamically script applications. Everything works as expected, except when using ByRef parameters. The below explanation is lengthy, but well worth the read. If you can help me, I'd gladly share this code which has greatly helped my development of extensible applications. I have developed an easy to use scripting engine for .NET that handles loading and unloading of a secondary AppDomain automatically. I call the object "SafeScriptingEngine", and it has properties for the source language, source code, and any needed references and imports. When its compile method is called, the code is compiled by the appropriate compiler, then it creates a new AppDomain, loads the compiled code into the AppDomain, and uses a Class Factory approach to return a well-known interface. This simple interface contains two functions called "MethodExists", which accepts a function name and a list of parameters then return a Boolean of whether the function exists, and "CallMethod", which again accepts a function name and a list of parameters then actually calls the function. Public Interface IRemoteLoader Function Invoke(ByVal methodName As String, ByVal parameters() As Object) As Object Function MethodExists(ByVal methodName As String, ByVal parameters() As Object) As Boolean End Interface So, an example of using this engine looks like: Dim sse As New SafeScriptingEngine() sse.Language = Languages.VisualBasic sse.SourceCode = "" & _ "Public Function UpperString(ByVal s As String) As String" & _ " Return s.ToUpper" & _ "End Function" If sse.Compile() Then If sse.MethodExists("UpperString", New Object() { "" }) Then MsgBox(sse.CallMethod("UpperString", New Object() { "this string will be converted to uppercase" })) End If End If All of this works great. There are no memory leaks, and all compilers, AppDomains, and assemblies are unloaded as desired and expected. In fact, I designed the engine to be inheritable such that functions can be created that are strongly typed. As you can see, the default engine expects a non-strongly-typed array of Objects. To prove the usability of the engine, I created a "SimpleStringScript" which inherits from the "SafeScriptEngine". The "SimpleStringScript" accepts only the part of code that does the manipulation, such as "s.ToUpper" in the example above. In the background, it adds function, parameters, and Return statement. Also, with the "SimpleStringScript", there is no need for "MethodExists" that accepts parameters. Instead, it has a "StringMethodExists" function that accepts no parameters, which then calls "MethodExists" on the base "SimpleStringScript" with a String Object as the parameter. Likewise, there is no need to call "CallMethod" with a function name and Object array. Instead, it has a "CallStringMethod" function that take a String as a parameter, which in turn calls the base "CallMethod" with the appropriate function name and the String parameter encased in an Object array. Public Class SimpleStringScript Inherits SafeScriptingEngine Public Function CallStringScript(ByVal s As String) As String Public Function StringMethodExists() As Boolean ... End Class Again, all of this works great, just as desired and expected. The problem arises when you create a script that uses ByRef parameters. I would like a function that looks like: Public Sub MyCustomFunction(ByRef e as MyEventArgs) e.MyObject.MyProperty = "some value" End Sub I quickly discovered that any parameter being passed into another AppDomain must be Serializable, as do any objects that are referenced in its hierarchy. Otherwise, it will throw a SerializationException when you try to pass in the parameter. So, I changed all objects that are referenced in the EventArgs to be Serializable, and that solved the problem when calling. However, upon return to the calling AppDomain, the objects and values in "e" are still the same as before the call. None of the manipulations taking place in the script from the secondary AppDomain are carried back to the calling AppDomain. I figure this is because, as expected with the Serializable objects, the "e" is being serialized, sent across the AppDomain boundary, then deserialized. When it is deserialized, an entirely new object is created. Changes made are not sent back across the boundary simply by using ByRef arguments. Unfortunately, I'm not sure exactly how to solve this problem. I think I should be sending an Interface as my argument, rather than an object of MyEventArgs. As long as the Interface is well-known in both AppDomains, I think the scripting AppDomain should know what to call, and when it does, the call should be marshaled back to the primary AppDomain via the Interface. Basically, the Interface is just a pointer back to the actual object. Can anyone confirm this to be True or False? If False, please HELP! If True, then is it possible to simply wrap the MyEventArgs object into an Interface, such as "IMyEventArgs", then change the scripted function to accept the Interface rather than the object, then pass an Interface rather than an object into the method? Would that suffice, so long as both AppDomains are aware of the Interface and anything it references? Obviously, if the Interface referenced a type that is not loaded in the secondary AppDomain, then there would be problems because the script would not know how to use it. Or, do I have to wrap the EventArgs into an Interface, as well as wrap every object that it references into an Interface. Meaning, again using the example above, would I also need to create an "IMyObject" Interface? My workaround for the time being is to return the object being manipulated as the return value, that way, the new object (created from deserialization) is again serialized upon return. However, this requires the scripter to know that they need to return it. Using C#, that is no big deal because the compiler will tell you when there is nothing returned. However, in Visual Basic, if you fail to supply a return value, you simply get Nothing. But, since I will be writing the scripts, I'll deal with the workaround for now. But, I sure would like ByRef to work across AppDomains. Any suggestions? Thanks in advance, Matthew ___________________________________ Matthew Roberts Framework Architect Business Process Solutions SOURCECORP Dallas, TX 75204 matthewroberts (at) srcp (dot) com Tag: BIFF8 Excel Reader Tag: 93854
  - 3
    - Which NIC will framework application use? I have a computer with two NIC cards...on different subnets. When I fire up a C# Framework application, how does it select which NIC to use for network access? Amil Tag: BIFF8 Excel Reader Tag: 93852
  - 4
    - i give up....parse string hello i want to parse/rplace/construct wahtever a string i get i read with directoryinfo out the root off my webapplikation Dim dirInfo As New DirectoryInfo(Server.MapPath("")) c:\inetpub\wwwroot\TEST i store this in a variable called physicalbasepath i list all folders in a datagrid and adds a buttoncollmn that executes using this which steps me one level into the filesystem Dim dirinfo As New DirectoryInfo(Server.MapPath(e.Item.Cells(1).Text)) ' where cell1 contains the full path of that dir i wanna go in to i store this in a variable called subphysicalbasepath i now have c:\inetpub\wwwroot\TEST and c:\inetpub\wwwroot\TEST\subfolder1 ' here we can get deep in so we must keep all from TEST\.....\and down i wanna turn this into http://server.domain.com/test/subfolder1 - this must be dynamic so i can use on any server and the folders can have any name i gets the urlpath using this Dim basepath As String = Request.Url.GetLeftPart(UriPartial.Authority) + ResolveUrl(Request.ApplicationPath) which gives me http://server.domain.com/test my though was to replace c:\inetpub\wwwroot\TEST\subfolder1 with basepath so it looks like this http://server.domain.com/test\subfolder1 then i can easy switch the \ to a / i can only accomplish this if i use this - replacing char with string Dim virtualpath1 As String = dirinfo.FullName.Replace("c:\inetpub\wwwroot\TEST", basepath) this gives http://server.domain.com/test/\subfolder1 which is what i want but not dynamic enough It wont work use this replace string to string Dim virtualpath1 As String = dirinfo.FullName.Replace(subphysicalbasepath,basepath) this gives c:\inetpub\wwwroot\TEST\subfolder1 Tag: BIFF8 Excel Reader Tag: 93848
  - 5
    - httpwebrequest when RSA/ACE securid server is involved Hello, I have an assembly, written in C#. The assembly runs under IE (6.0 SP1). IE accesses a web site on which a reverse proxy with an RSA/ACE secureid is installed. When this happens an authentication process takes place and after its completion, the web request goes through and completes successfuly. Naturally, any further http requests to the same site will not have to re-authenticat. However, my C# assembly runs under IE and tries to invoke an http request via the standard httpwebrequest class. I am setting HttpWebRequest.Credentials = CredentialCache.DefaultCredentials still, it does not help. Any idea what I am missing here? Thanks, Ilan Tag: BIFF8 Excel Reader Tag: 93841
  - 6
    - Problems installing Framework 1.1 of WinXPsp2 Just bought new notebook with Windows XP pro sp2. Trying to install ACT!, which requires .net framework 1.1. But I get the follow message during the installation of .net: application has generated an exception that could not be handled process id=0xc48(3144) thread=0xc9c(3228). The installation is then halted. Do I need to install Framework 2.0 beta?, or is is a matter of firewall settings, etc.? Thanks Tag: BIFF8 Excel Reader Tag: 93839
  - 7
    - corrupted net 1.1 framework install I have a corrupted framework install. I can not uninstall or reinstall. I tried to reinstall following the kb article but I get the same error. The install is looking for a temp file tmp4B.tmp and can't find it. Any ideas? Thanks Fr. Robert Tag: BIFF8 Excel Reader Tag: 93837
  - 8
    - Combobox text not in list strange behaviour Here is a weird one. I have a combobox that accepts and displays values that are not in the list. However if I do a droppedDown = true in the onEnter event handler and then tab to another combobox, the text value is reset to null/empty string. My solution at this point is to separate the two comboboxes with a textbox so that doesn't happen. (Note that it also resets to null if i step through through the droppeddown = true statement.) If anyone has seen this or heard of fix for it, please let me know. Thanks, Carl Here are code snippets pertainent to this: ' 'cboPaymentType ' Me.cboPaymentType.Enabled = False Me.cboPaymentType.Location = New System.Drawing.Point(152, 160) Me.cboPaymentType.Name = "cboPaymentType" Me.cboPaymentType.Size = New System.Drawing.Size(104, 21) Me.cboPaymentType.TabIndex = 2 ' 'cboPaymentMethod ' Me.cboPaymentMethod.Enabled = False Me.cboPaymentMethod.Location = New System.Drawing.Point(320, 160) Me.cboPaymentMethod.Name = "cboPaymentMethod" Me.cboPaymentMethod.Size = New System.Drawing.Size(104, 21) Me.cboPaymentMethod.TabIndex = 4 'payment type Me.cboPaymentType.DataBindings.Add("SelectedValue", Me.OrderDS, "Orders.OrdersOrderPayments.PaymentTypeFK") ' binding to the Text property appears to allow a value not in the list to be entered, saved, and displayed. Me.cboPaymentType.DataBindings.Add("Text", Me.OrderDS, "Orders.OrdersOrderPayments.PaymentTypeFK") Me.cboPaymentType.DataSource = Me.PaymentTypeDS Me.cboPaymentType.DisplayMember = "PaymentType.PaymentTypeName" Me.cboPaymentType.ValueMember = "PaymentType.PaymentTypeName" ' do it twice to get around bug Me.cboPaymentType.SelectedIndex = -1 Me.cboPaymentType.SelectedIndex = -1 'payment method Me.cboPaymentMethod.DataBindings.Add("SelectedValue", Me.OrderDS, "Orders.OrdersOrderPayments.PaymentMethodFK") ' binding to the Text property appears to allow a value not in the list to be entered, saved, and displayed. Me.cboPaymentMethod.DataBindings.Add("Text", Me.OrderDS, "Orders.OrdersOrderPayments.PaymentMethodFK") Me.cboPaymentMethod.DataSource = Me.PaymentMethodDS Me.cboPaymentMethod.DisplayMember = "PaymentMethod.PaymentMethodName" Me.cboPaymentMethod.ValueMember = "PaymentMethod.PaymentMethodName" ' do it twice to get around bug Me.cboPaymentMethod.SelectedIndex = -1 Me.cboPaymentMethod.SelectedIndex = -1 Private Sub cboPaymentMethod_Enter(ByVal sender As Object, ByVal e As System.EventArgs) Handles cboPaymentMethod.Enter CType(sender, ComboBox).DroppedDown = True End Sub Private Sub cboPaymentType_Enter(ByVal sender As Object, ByVal e As System.EventArgs) Handles cboPaymentType.Enter CType(sender, ComboBox).DroppedDown = True End Sub Tag: BIFF8 Excel Reader Tag: 93836
  - 9
    - HttpWebRequest ->HttpWebResponse question Hi... I ran into an odd circumstance using HttpWebRequest. Specifically, when you call GetResponse() it throws a WebException, to quote the msdn page, Abort was previously called. -or- The time-out period for the request expired. -or- An error occurred while processing the request. The last item is the part I find quizzical. "An error occurred while processing the request" appears to cover any non-200 return status while ignoring that, say, a 404 or a 500 status *can* have a payload that is of interest. A custom error page, or a 500-page might have information about what went wrong. Is there any way to get ahold of the payload when the return status is not 200? GetResponse errors out, and I can't find a property to stop that. Thanks -Mark Tag: BIFF8 Excel Reader Tag: 93835
  - 10
    - DirectorySearcher.FindOne() fails when LDAP path contains "/" Hello, I have a method that is used to find all of the distribution lists and security groups that a user belongs to. This works fine, except when the LDAP path looks like the following: CN=aaa/ aaaaa,OU=Distribution Lists,DC=string,DC=string,DC=string,DC=com I've found that everytime the DirecotrySearcher.FindOne() encounters a path that contains a '/' in the CN portion, it throws an exception. Below is the exception: Source: System.DirectoryServices Message: Unknown error (0x80005000) Stack Trace: at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail) at System.DirectoryServices.DirectoryEntry.Bind() at System.DirectoryServices.DirectoryEntry.get_AdsObject() at System.DirectoryServices.DirectorySearcher.FindAll(Boolean findMoreThanOne) at System.DirectoryServices.DirectorySearcher.FindOne() at ADUtilityTester.ADUtilities.getDLList(String sDomain, String sUser) in c:\\documents and settings\\username\\my documents\\visual studio projects\\adutilitytester\\adutilities.cs:line 74 Line 74 is: SearchResult schRes = ds2.FindOne(); I've tried escaping it, but then it just doesn't find anything. Any ideas on how to get around this problem? -- Michael Bayha Tag: BIFF8 Excel Reader Tag: 93834
  - 11
    - Setting Printer Hi, can anyone pleasse tell me how to set the lpi on a doe matrix printer via code. VB.Net preferablly. It could be thdough windows API, it doesn't matter. Thanks Tag: BIFF8 Excel Reader Tag: 93826
  - 12
    - windows service Hi, I have created a Windows service. In the project there is one service and one installer. I have also created a Setup project. When I run my msi file the service will not be installet into the Computer Manager/Service... the application are installed into the Porgram Files/MyApp folder. How can I trouble shoot this? Thanks Julia Tag: BIFF8 Excel Reader Tag: 93824
  - 13
    - Word wrapping in Graphics.DrawString breaks words at umlauts Hi, I use Graphics.DrawString(string, Font, Brush, Rectangle, StringFormat) to render a string inside a rectangle with word wrapping. It works fine so far, but: If words contain german umlauts (ä, ö, ü etc.), lines are broken before or after these characters. The umlauts seem to be considered as delimiter characters. I can't find a language setting in the Graphics class or in the StringFormat class either. I tried to set stringFormat.SetDigitSubstitution(System.Globalization.CultureInfo.InstalledUICulture.LCID,StringDigitSubstitute.Traditional); but to no effect. TIA Franz Tag: BIFF8 Excel Reader Tag: 93821
  - 14
    - Line numbers of methods in dynamically generated assemblies Hello, I am dynamically compiling .cs files to In-Memory assemblies at runtime using CodeDom. This works fine. The resulting assembly is parsed via reflection to detect the implemented class and the the methods of that class. This works fine, too. Now, I want to match the detected methods to the responding lines of code of the original source file. This is the problem! Maybee I have overseen something, but after a hard day trying to understand and use the System.Diagnostics.SymbolStore namespace, I am completely stuck. The methods of the SymbolStore seem to be only partially implemented and they are quite poorly documented. Does anyone have an idea how to get the line numbers of the first and the last line of a method, from which I have the MethodInfo? Any idea is greatly appreciated! Thanks in advance Uli Tag: BIFF8 Excel Reader Tag: 93820
  - 15
    - Cost of using functions [vb.net] I was wondering if the use of functions decreases performance over placing all code after each other. For example: Instead of having function write anything to the screen using Response.Write(strMessage), I usually call a function DisplayMessage (strMessage), but now I'm wondering if this has any impact on the performance, or does the Framework recode (or how it is called) this to effecient code anyway. The main advantage is that, if I decide that those functions should not write anything to screen, I just have to disable that in only one place. Plus readability is increased :) Merely curious, as it is not really a performance issue, I'm wondering what the groups thoughts are about this. -- Message posted via http://www.dotnetmonster.com Tag: BIFF8 Excel Reader Tag: 93817
  - 16
    - List of users for a folder How to retrieve a list of groups and/or users that have access permission to a folder? Thank you. Tag: BIFF8 Excel Reader Tag: 93815
  - 17
    - BIFF8 Excel Reader Besides using Interop and ADO.NET, I;d like to know where can I get a BIFF 8 Excel reader in .NET which is free or GNU license? I need a BIFF8 reader to read an excel file upload by a user. I don't wish to use interop and ado.net at the moment. I found a writer instead @ www.freevbcode.com/ShowCode.Asp?ID=6856 although this writer is in VB6 format. Tag: BIFF8 Excel Reader Tag: 93814
  - 18
    - get application path Hi, how can I get the path of my application? If the application is located in C:\Program Files\MyApp, I want to be able to get this path in the code so I can save a text file in this location. Thanks Julia Tag: BIFF8 Excel Reader Tag: 93810
  - 19
    - Problem deploying C# application with ClickOnce Hi all, I've created a simple application in C# to test for ClickOnce deployment. After I've compiled the exe, I created the deployment manifest and the application manifest with "mageui.exe", and then put it onto a folder which could be recognized by IIS. I tried to click on the .application file in Windows Explorer, and the application is installed with no problem. Then I tried to do the same thing through a web browser, typing the URL directly. The update screen comes out normally, but after that an error message telling me that "Unable to continue. The application is improperly formatted. Please contact the vendor." is shown. The exception is attached at the end of this message. Since the XML files are created by mageui.exe without being modified, I think they should have no formatting problem. And I have already specified the Publisher. So is there anything that could cause this problem? (FYI I'm using English WinXP, and have my default language for non-Unicode programs set to Chinese (Taiwan)). Thank you. Dominic --------------------- Exception given: Windows version: 5.1 system.deployment.dll (in C:\WINDOWS\Microsoft.NET\Framework\v2.0.40607) version: 2.0.40607.42 (beta1.040607-4200) mscorwks.dll version: 2.0.40607.42 (beta1.040607-4200) dfdll.dll version: 8.0.40607.42 (beta1.040607-4200) Subscription Url: C:\Documents and Settings\User\Start Menu\Programs\dominic\Sample application using ClickOnce deployment..appref-ms (23/03/05 12:41:34 PM) Activate manifest: Activation of C:\Documents and Settings\User\Start Menu\Programs\dominic\Sample application using ClickOnce deployment..appref-ms resulted in exception. Type: System.Deployment.ManifestParseException Exception reading manifest from file 8b550599-633d-4caf-a070-6f0008b0f4ac.application: the manifest could be invalid or the file could not be opened. Source: System.Deployment Stack trace: at System.Deployment.ManifestReader.ExceptionHelper(String filename, Exception ex) at System.Deployment.ManifestReader.FromDocument(String docPath, ManifestType manifestType) at System.Deployment.DownloadManager.DownloadManifest(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ManifestType manifestType) at System.Deployment.DownloadManager.DownloadDeploymentManifestDirect(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, IDownloadNotification notification, DownloadOptions options) at System.Deployment.DownloadManager.DownloadDeploymentManifest(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, IDownloadNotification notification, DownloadOptions options) at System.Deployment.ApplicationActivator.PerformDeploymentUpdate(SubscriptionState subState) at System.Deployment.ApplicationActivator.ProcessOrFollowShortcut(String shortcutFile, TempFile& deployFile) at System.Deployment.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, String deployLocalCachePath, Boolean isShortcut) at System.Deployment.ApplicationActivator.ActivateDeploymentWorker(Object state) --- Inner Exception --- Type: System.Xml.XmlException There are multiple root elements. Line 1, position 49. Source: System.Xml Stack trace: at System.Xml.XmlTextReader.Throw(Exception e) at System.Xml.XmlTextReader.Throw(String res, String arg) at System.Xml.XmlTextReader.Throw(Int32 pos, String res) at System.Xml.XmlTextReader.ParseDocumentContent() at System.Xml.XmlTextReader.Read() at System.Deployment.XmlFilteredReader.Read() at System.Xml.XmlTextReader.Skip() at System.Deployment.XmlFilteredReader.Read() at System.Xml.XmlValidatingReader.Read() at System.Deployment.ManifestReader.FromDocument(String docPath, ManifestType manifestType) Tag: BIFF8 Excel Reader Tag: 93808
  - 20
    - Clientside scripting and Popup windows. How do I develop client-side popup windows that they have at http://my.msn.com/? I know that some of this will be available in Asp.net 2.0. I may need this before the end of the release of 2.0. I know about confirm and alert, but I need something more sophisticated. Tag: BIFF8 Excel Reader Tag: 93793
  - 21
    - Serialize / Deserialize sub-classed TreeNode I have created a new class, inherited from TreeNode, and wish to be able to use binary serialization with it. I have marked the class as serializable, however the object will not deserialize correctly (error: "The constructor to deserialize an object of type xMapNodeSerialize.MapNode was not found"). I have also thought about implementing ISerializable, however the base TreeNode class already implements this and does not allow protected access to it's special constructor or GetObjectData override. Any ideas anyone? Thanks, Chris simple code example: Imports System.Runtime.Serialization <Serializable()> _ Public Class MapNode Inherits TreeNode #Region "Constructors" Public Sub New() MyBase.New() End Sub Public Sub New(ByVal text As String) Me.New() MyBase.Text = text End Sub #End Region End Class Tag: BIFF8 Excel Reader Tag: 93792
  - 22
    - SortedList question-- easy way to look for dupes? Hi everyone, I've been reading through the MSDN documentation on SortedLists and didn't find anything that leapt out at me about this, so I thought I'd ask; is there a "good" way to check if a SortedList has duplicate values? What about looking for duplicate values in two SortedLists?-- is there a reccomended method for looking for dupes in that instance? Tag: BIFF8 Excel Reader Tag: 93791
  - 23
    - How to configure the DateTimePicker control to accept 24:00? I have a DateTimePicker control on a Windows form. What I want is to configure it to recognise 24:00:00 as a valid time. I only intend to use the return value as a string (i.e. not DateTime variable) How can I do this? Many thanks. Tag: BIFF8 Excel Reader Tag: 93782
  - 24
    - Producer/Consumer example I am building an application where data is coming in from a hardware deveice attached to the serial port. The data needs to be queued ASAP. I figured a could create a custom class containing this data and store it in an ArrayList for future processing. I want to process this data continually so that is could be preserved in case of a system failure. I was thinking of implement a producer/consumer relationship using threading. However, I haven't been able to find an example that explains things in a way that I can digest. Does anyone know of any good resources for developing producer/consumer systems with C# and Threading? Thanks. Ryan. Tag: BIFF8 Excel Reader Tag: 93777
  - 25
    - performance issue when the interpolation mode (GDI+) Hi, I have a performance issue when the interpolation mode is set to Bicubic. The image (of size 1 MB) is zoomed 10 times. When the image is viewed using scroll bars in a picturebox control, there is a choppy effect, where as, when the interpolation mode is set to HiQualityBicubic (or for any other mode, apart from Bicubic), this effect is not to be seen. Any ideas... Thanks in Advance Tag: BIFF8 Excel Reader Tag: 93774
- Next
  - 1
    - Read / write text file? I need to update some lines in a text files. I would like to open the file, read line by line and change the lines that should be changed and then when finished the file should have been changed. I know how to do this if I open one file and write out to a second file, but how can I do this with a single file without creating a new one? Olav Tag: BIFF8 Excel Reader Tag: 93769
  - 2
    - mutex locks: should I lock out concurrent readers, or just writers? Or should I say, when I have data members that can be read from multiple threads, should I put a lock around read-only access to those members in addition to the write-accesses of those members? What if a reader attempts to read the data while the writer is in the midst of writing to it? Thanks, -- kov Tag: BIFF8 Excel Reader Tag: 93767
  - 3
    - Threads how to get variables... Hi! How i pass variables into threads? For example: Dim t1 As New Thread(AddressOf CfgInject) Dim t2 As New Thread(AddressOf CfgInject) t1.start t2.start Cfginject, can be called n times, i need to now inside the function what is the current thread... Tag: BIFF8 Excel Reader Tag: 93761
  - 4
    - How do I print to a PNG-file? Hi! A have developed a windows app in VB.NET that has some printing of charts and such stuff. Is there an easy way to save the outprint in an PNG-file instead? I want exactly the same look in the image as in the outprint. -- Regards, Lars JÃ¶nson Tag: BIFF8 Excel Reader Tag: 93759
  - 5
    - HttpWebRequest with ssl problem Hi support I' m sending requests to a web server over an ssl connection to a server with the HttpWebRequest class. I can't control the server. I make a login, send some requests but the server has no logout. This works only once. The second time I get a http error. I restart the application and everything works fine again. The programmer of the server application advised me to just destroy the ssl connection and after that log in again. That's the point: how can I destroy the ssl connection in visual basic.net. Regards Dieter Tag: BIFF8 Excel Reader Tag: 93758
  - 6
    - Garbage Collection Hi, I have a windows app that i'm using to transfer images from one SQL DB to another doing some processing inbetween because the DB table structures to hold the images are different. What i'm finding is that the process fails after several hundred images with an Out Of Memory Exception. I can see from Task Manager that my app is chewing up memory (over 1GB) just before I get this error. I've have double checked all my code and i'm closing all DB connections and memory streams etc so in theory there should be no memory leaks. It just seems that the garbage collector is not being called, even when I make an explicit call to GC.Collect it doesn't seem to get called... Any ideas? Tag: BIFF8 Excel Reader Tag: 93756
  - 7
    - Proposed MSDN Subscription Changes - VERY BAD!!! I urge every developer who has an MSDN subscription (Universal) to petition MS to change their proposed ideas on Visual Studio Team Suite (VSTS). Depending on what you read, they are proposing to not include it or raise the price to between $5,000 and $10,000. Every developer who has helped MS make loads of cash of these past many years needs to write to them. Let them know they are about to alienate the one group that always and consistently helps them be successful. It is the most ridiculous thing they've ever proposed. Unbelievable!!! http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackId=2b58b8db-5bba-4dfc-be10-78ad43686b3b MICROSOFT PLEASE RECONSIDER. YOU WILL LOSE SALES. YOU WILL ALIENATE ALL CLASSES OF DEVELOPERS! We are the ones that stick up for you when everyone bashes MS. Help us help you! GClark Tag: BIFF8 Excel Reader Tag: 93755
  - 8
    - dialer in asp.net Hi, I'm developing an web application with Visual Studio .NET 2003 using c#. How can i give to the user an option to use a button that will dial a phone number (like the dialer in access) Thanks Tag: BIFF8 Excel Reader Tag: 93754
  - 9
    - const byte[] ? Hi group How i can do that ? public const byte[] B = new byte[] {0x01,0x02,0x03} // compile error : expression must be constant. I try a other declaration, but no results. for the moment i make it readonly, but it is a little different ... thanks ROM Tag: BIFF8 Excel Reader Tag: 93752
  - 10
    - GC in .net What is the name of the Gc alogorithm used by .net? What is the difference between Finalize() and Destructor()? Tag: BIFF8 Excel Reader Tag: 93742
  - 11
    - I miss those old events in this brave new world! This is just a comment. I was very surprised to find out that there are no named events support in .NET framework! Sure, mutex objects can do most of IPC work, but there are some cases that mutexes do not fit in (because mutexes have a unique thread ownership feature). For example (this may be very hard to understand, just like all other synchronizing problems): 1. A parent process spawns a child process to do a job. 2. The parent has to make sure that the child starts the job or the child exits prematurely on errors. It also has to have a way to tell the child to stop working. 3. So in this brave .NET world, I have only one choice - two mutexes for the IPC. One is for 'quit' signal, the other is for 'error' signal (when errors occur, the child process exits). 4. Now the parent has the following logic: get_unique_signal_names(); // Guid is used create_quit_signal(); // intially owned create_error_signal(); // not initially owned; create_child_process_config(); // create a config file for the child process create_child_process_with_config(); // spawn the child process with created config file wait_for_child_process_or_error_signal(); // wait any of them if(process exited) { call_error_handler(); } else { user_ineration(); // provide UI to let user stop child process } 5. The child process does this logic: get_signal_names_from_config(); // they are in app.exe.config open_quit_signal(); open_error_signal(); try { intialization_for_job(); } catch(error) { set_error_signal(); return -1; } start_job(); // e.g., starting a listening socket wait_for_quit_signal(); // enter wait state; 6. Everything is fine, right? But there is only one *small* problem. This problem is caused by the unique feature of mutex objects - thead ownership. Simply put, the above logic does not gurantee wait_for_child_process_or_error_signal() always indicate the correct situation. The error signal is created not owned. Since no thread has ownership of this mutex, its state is always *signaled*; unlike event objects, they are either signaled or nonsignaled. So it is not 100% safe that when the code gets to wait_for_child_process_or_error_signal(), the child process has already does open_error_signal()! It took me hours to find out this *small* problem. I think it's a small problem because programs now runs on fast computers, the chance is very rare for the child process get choked before open_error_signal() and while the parent process gets to wait_for_child_process_or_error_signal(). 7. There is a solution. But it is clumsy (anyone who gets to this point please point out a good way if he/she know one): For the parent process: for(;;) { Thread.Sleep(500); // don't exhaust CPU time // wait for the child process to get ownership of this signal if(done_signal.WaitOne(500, true)) // in case the child already has it { done_signal.ReleaseMutex(); // well, have to do get/release in pairs } else break; } For the child process: open_error_signal(); get_ownership_of_error_signal(); // get ownership - a simple wait 8. That's why I miss those named events in the ugly old world. With named events, I don't have to add the logic in note 7. At last, I finished it. I thank for any explanation on why named events extinct in the new world (except the performance issue). Tag: BIFF8 Excel Reader Tag: 93740
  - 12
    - Should I use XML or not? Hello, I am writing a word add-in in C#. This add-in has to attach some metadata to bookmarks in the document. = The metadata is stored in Word document variables. Typical metadata can consist of a string identifier, three lists of [0 = to 50] person-names each and about 5 Yes/No flags. The problem is that I have to parse the metadata whenever the user moves = the cursor onto bookmarked text so it has to be very fast, otherwise = moving through the document will feel sluggish. I was thinking of formatting the metadata using XmlTextWriter and = parsing it using XmlTextReader. However, I am not familiar with these classes and I am afraid that this = approach may prove too slow on computers that are not state of the art. The alternative is formatting and parsing the strings myself, perhaps = using some combination of string.Split, string.Join, string.IndexOf and = StringBuilder. Since the metadata is only intended for the internal operation of the = add-in, it can be as ugly as I want (in fact, I was thinking about = obfuscating it do discourage users from messing with it but this may add = another slowdown). What would you suggest? Thank you, Alex. --=20 Please replace myrealbox with alexoren to reply by email. Tag: BIFF8 Excel Reader Tag: 93734
  - 13
    - CreateProcessWithLogonW doesn't work with XP service pack 2 I posted this in another group, so, sorry if you have already read this. I'm trying to run an application under another user within a winform app writen in C#. I have tried a number of different things, but it seems that the CreateProcessWithLogonW function should work to do what I need to do. This appears to work just fine in Windows 2000 and XP with service pack 1, but it doesn't work with XP service pack 2 installed. I'm sure it's one of the "Enhanced security features" of service pack 2, but I can't seem to get this to work. The function returns a 1 indicating that it worked fine, but the applcation that I'm trying launch does not launch. To give a little background on what I'm doing: I have written a small app that is basically just an interface for the netsh command to change network setting for the user. The users do not have admin rights on their machines, but a select few need to be able to change their IP addresses for buisness reasons. Because of this, I basically just call the CreateProcessWithLogonW function to start run the netsh command under an admin account on the machine to change the IP address to whatever the user specifies in the interface that I provided. As a test, I have created two very simple windows apps. The first one calls the CreateProcessWithLogonW function to login as another account on the machine. It then calls another simple application that uses the WindowsIdentity to show the current user. This works fine on Win2K and XP sp1, but not with service pack 2. If anyone know how to get around this, that would be great. Thanks, Jerry Tag: BIFF8 Excel Reader Tag: 93730
  - 14
    - Update shared files using Updater Application Block Hi there, I have about 20 applications. There are many dll files that the applications share. I want to avoid having the duplicated dll files. Therefore, I create a floder for these dll files. Now I want to create an updater sustem using Updater Application Block. I know that the updater is used to individually update applications. However, can I update an application along with some dll files in a shared folder? I would appreciate your feedback. Juri Tag: BIFF8 Excel Reader Tag: 93729
  - 15
    - Exception thrown using DirectorySearcher.FindOne() Hello, I have a method that is used to find all of the distribution lists and security groups that a user belongs to. The works fine, except when the LDAP path looks like the following: CN=aaa/ aaaaa,OU=Distribution Lists,DC=string,DC=string,DC=string,DC=com I've found that everytime the DirecotrySearcher.FindOne() encounters a path that contains a '/' in the CN portion, it throws an exception. Below is the exception: Source: System.DirectoryServices Message: Unknown error (0x80005000) Stack Trace: at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail) at System.DirectoryServices.DirectoryEntry.Bind() at System.DirectoryServices.DirectoryEntry.get_AdsObject() at System.DirectoryServices.DirectorySearcher.FindAll(Boolean findMoreThanOne) at System.DirectoryServices.DirectorySearcher.FindOne() at ADUtilityTester.ADUtilities.getDLList(String sDomain, String sUser) in c:\\documents and settings\\username\\my documents\\visual studio projects\\adutilitytester\\adutilities.cs:line 74 Line 74 is: SearchResult schRes = ds2.FindOne(); I've tried escaping it, but then it just doesn't find anything. Any ideas on how to get around this problem? -- Michael Bayha Tag: BIFF8 Excel Reader Tag: 93727
  - 16
    - System.Collections.DictionaryBase.GetEnumerator cannot be overload Hello, I've tried to write an method overriding System.Collections.DictionaryBase.GetEnumerator(), but my C# compiler (VS .NET 2003) outputed 'error CS0506'. This means System.Collections.DictionaryBase.GetEnumerator() is not virtual one, but in the .NET class library reference, it is described as 'public virtual IDictionaryEnumerator GetEnumerator();'. Also, the object browser in VS.NET 2003 says DictionaryBase.GetEnumrator() is 'public virtual new System.Collections.IDictionaryEnumerator GetEnumerator ( )'. Is this a bug of the compiler or the document? Or Is there something wrong in my understandings? Tag: BIFF8 Excel Reader Tag: 93725
  - 17
    - Question on - Automatic compilation of VB.NET files on a Web Server Not sure if this is the correct newsgroup. Could be the IIS. Hopefully someone can answer my question. We are migration an ASP Web App to VB.NET. One of the benefits we're enjoying so far with ASP is that we do not have to worry about a build release. When an ASP file is modified and tested, we just deploy that file to the production Web server through Visual SourceSafe without worrying that we are releasing someone elses untested/unfinished code out. Now I am hoping that .NET provides the same scenario where all we need to do is copy the .aspx and .vb files to the Web Server, and all the .vb files would automatically get compiled into the assembly when an .aspx file is requested. Meaning that we wouldn't have to compile the application into a DLL assembly. The environment would recognize that the .vb file has changed and would get compiled into the existing assembly. My question, does .NET work this way? Thank you. Tag: BIFF8 Excel Reader Tag: 93724
  - 18
    - Web Browser control throws exception when trying to navigate to ur I have written a small app to help test code generated by Xslt tranformations, these transformations are performed by various components - basically this is a test rig for the components and Xslt they use. All works fine the first time I invoke the method, save the output to file and then browse to this file with the browser component. However, if I do the same action again I get a "Exception has been thrown by the target of an invocation." exception thrown when calling the Navigate() method (passing in the same url as worked previously). The InnerException is "The requested resource is in use.". If I change the tool to point to a different component/xslt each time I invoke the test then all is OK, it is just doing this when I do the same url twice in a row. I suspect it may be something to do with the some resources referenced in the html not being available and the browser control not being ready for use again - but why would it work for a different url? Please help!!! Thanks -------------------------- Shaun Venus emailid: sunevnuahs domain: hotmail.com -------------------------- Tag: BIFF8 Excel Reader Tag: 93720
  - 19
    - updating a shared files using Updater Applicatin Block Hi there, I have about 20 applications. There are many dll files that these applications share. I want to avoid having the duplicated dll files. Therefore, I crate a folder for these dll files. Now I want to create an updater system using Updater Application Block. I know that Updater Application Block is used to individually update applications. However, can I update an application along with some dll files in a shared folder? I would appreciate your feedback! Tag: BIFF8 Excel Reader Tag: 93718
  - 20
    - Update appls and shared dlls using Updater Application Block Hi there, I have about 20 applications. There are many dll files that these applications share. I want to avoid duplicating the dll files. Therefore, I crate a folder for them. Now I want to create an updater system using Updater Application Block. I know that Updater Application Block is used to individually update applications. However, can I update an application along with some dll files in a shared folder? I would appreciate your feedback! Tag: BIFF8 Excel Reader Tag: 93717
  - 21
    - Deserialize changed object Hi, I want to deserialize a binary serialized object that had been serialized with a slightly different class definition. (a new member had been added). Instead of success, i get error indicating object had been serialized with N members and now has N+1 members. Any elegant solutions to this problem? Thanks, Mark Tag: BIFF8 Excel Reader Tag: 93716
  - 22
    - Sending to USB? I've been asked if I could convert my app to send raw printer data to USB rather than serial/COM. Right now, we open the com port and ship out our text printer data to that port (a label printer). I've searched the web, and there are comments suggesting that its "probably" a similar operation - I'd like a little more confidence that it is. Does anyone ship data to a USB printer (this printer is an Intermec barcode label printer, but that shouldn't matter) - how is this handled in code? I haven't found a USB port, similar to COM1, LPT1, etc... Thanks Mike Tag: BIFF8 Excel Reader Tag: 93714
  - 23
    - ICodeCompiler defaults to /D:TRACE /D:DEBUG Greetings, I've noticed that assemblies built using ICodeCompiler for C# (CSharpCodeProvider) appear to have been compiled with the /D:TRACE and /D:DEBUG compiler flags even though they are not present in the CompilerParameters.CompilerOptions string. I know this because the metadata for the assembly includes strings used in the Trace.WriteXXX() and Debug.Assert() statements in the code. Is this true? Is there a way to change this default behavior? Tag: BIFF8 Excel Reader Tag: 93711
  - 24
    - ICodeCompiler for MCppCodeProvider Hi, I'm trying to create an ICodeCompiler using the following code: CodeDomProvider cdp = new Microsoft.MCpp.MCppCodeProvider(); ICodeCompiler icc = cdp.CreateCompiler(); However, CreateCompiler() returns null. Is this not implemented? Cheers, \\Marc ps-I'm using VS.NET 2003. Tag: BIFF8 Excel Reader Tag: 93709
  - 25
    - Access to ptinting progress window Hi quys. Is there anyway to change any parameters of the pop-up windows that shows the printing progress and printpreview progress? Tag: BIFF8 Excel Reader Tag: 93707

Besides using Interop and ADO.NET, I;d like to know where
can I get a BIFF 8 Excel reader in .NET which is free or
GNU license? I'm not interested to get a third party
which need to pay.

I need a BIFF8 reader to read an excel file upload by a
user. This BIFF8 reader need to to be perfect but can
read all the values in a few worksheets. I don't wish to
use interop and ado.net at the
moment.

I found a writer instead @
www.freevbcode.com/ShowCode.Asp?ID=6856 although this
writer is in VB6 format.

Top