Chilkat • HOME • Android™ • AutoIt • C • C# • C++ • Chilkat2-Python • CkPython • Classic ASP • DataFlex • Delphi DLL • Go • Java • Node.js • Objective-C • PHP Extension • Perl • PowerBuilder • PowerShell • PureBasic • Ruby • SQL Server • Swift • Tcl • Unicode C • Unicode C++ • VB.NET • VBScript • Visual Basic 6.0 • Visual FoxPro • Xojo Plugin
(PowerBuilder) CSV Get Contents of Cell using Row Index and Column NameDemonstrates the GetCellByName method.
integer li_rc integer li_Success integer li_BCrlf oleobject loo_Sb oleobject loo_Csv string ls_CellContent // We have the following CSV... // permalink,company,numEmps,category,city,state,fundedDate,raisedAmt,raisedCurrency,round // lifelock,LifeLock,,web,Tempe,AZ,1-May-07,6850000,USD,b // mycityfaces,MyCityFaces,7,web,Scottsdale,AZ,1-Jan-08,50000,USD,seed // flypaper,Flypaper,,web,Phoenix,AZ,1-Feb-08,3000000,USD,a // infusionsoft,Infusionsoft,105,software,Gilbert,AZ,1-Oct-07,9000000,USD,a // gauto,gAuto,4,web,Scottsdale,AZ,1-Jan-08,250000,USD,seed li_BCrlf = 1 loo_Sb = create oleobject // Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0 li_rc = loo_Sb.ConnectToNewObject("Chilkat.StringBuilder") if li_rc < 0 then destroy loo_Sb MessageBox("Error","Connecting to COM object failed") return end if loo_Sb.AppendLine("permalink,company,numEmps,category,city,state,fundedDate,raisedAmt,raisedCurrency,round",li_BCrlf) loo_Sb.AppendLine("lifelock,LifeLock,,web,Tempe,AZ,1-May-07,6850000,USD,b",li_BCrlf) loo_Sb.AppendLine("mycityfaces,MyCityFaces,7,web,Scottsdale,AZ,1-Jan-08,50000,USD,seed",li_BCrlf) loo_Sb.AppendLine("flypaper,Flypaper,,web,Phoenix,AZ,1-Feb-08,3000000,USD,a",li_BCrlf) loo_Sb.AppendLine("infusionsoft,Infusionsoft,105,software,Gilbert,AZ,1-Oct-07,9000000,USD,a",li_BCrlf) loo_Sb.AppendLine("gauto,gAuto,4,web,Scottsdale,AZ,1-Jan-08,250000,USD,seed",li_BCrlf) loo_Csv = create oleobject // Use "Chilkat_9_5_0.Csv" for versions of Chilkat < 10.0.0 li_rc = loo_Csv.ConnectToNewObject("Chilkat.Csv") loo_Csv.HasColumnNames = 1 li_Success = loo_Csv.LoadFromString(loo_Sb.GetAsString()) // Get the contents of the cell at row 2 for the "city" column, which is "Scottsdale". // Indexes are 0-based. The 2nd row is at index 14. // (The row of column names is not a data row.) ls_CellContent = loo_Csv.GetCellByName(1,"city") Write-Debug ls_CellContent // Output should be "Scottsdale" destroy loo_Sb destroy loo_Csv |
© 2000-2025 Chilkat Software, Inc. All Rights Reserved.