xlrd - How to get line number in excel sheet using python? -

-

मेरे पास इस तरह एक एक्सेल शीट है: 

  एबीसीडीईएफजी 1 0 0 0 2 0 0 3 0 4 5 0 0 0 0 0 0 0 0 0 0 0   
 और हर '0' कुछ डेटा मूल्यों का प्रतिनिधित्व करता है, मैं मूल्यों को पढ़ रहा हूं और उन्हें मेरे मूल डेटा के साथ तुलना कर रहा हूं, जब डेटा मैच विफल रहता है, यह संदेश देता है। मुझे जो चाहिए, वह एक्सेल शीट की लाइन नंबर और साथ ही कॉलम नंबर या विशेषकर CELL स्थान को वापस करना है। कृपया यह करने में मेरी मदद करें!   
 
 
 इसे आज़माएं:  
  import xlrd वर्कबुक में शीट के लिए कार्यपुस्तिका = xlrd.open_workbook ('book.xls')। शीट्स (): रेंज में पंक्ति (शीट। एनआरओ): कॉलम रेंज (शीट। एनकॉल) के लिए: प्रिंट "पंक्ति :::::" , पंक्ति प्रिंट "कॉलम ::", कॉलम प्रिंट "मान :::", शीट। कोल (पंक्ति, कॉलम)। मूल्य   
 यह आपको सटीक  पंक्ति ,  स्तंभ  संख्याएं और  सेल  मान

Comments

Post a Comment

Popular posts from this blog

php - How to filter values fetched from database on the basic of comma included? -

-
Image
I have some values ​​in my database in the column, as I have been shown in the picture below, Now if you notice there over there In the position of number three, we have the value, which is Italian, pizzeria (pizza), there may be some other values ​​that can be included in the Italian, pizzeria (pizza) like COMMA (,) Yes, as we can see in the picture below, Now I want to get all the values ​​of php (select * from tablename), but if the value is included in COMMA, then I Any way to filter out? I just want to select values ​​that do not have any commas, thanks in advance? Unless there is a pregate in my knowledge, or an array filter can help. would not like predicate: Choose * Where 'Business' food is not like '%,%' from the tablet name;
Read more

android - How to save result? -

-
I am a rookie in Android programming I have a little problem when I have a visual image , I make that image invisible and set one button in visible. My problem is how can you save it? For example, I click on ImageView, the button shows and ImageView disappears. And I get out of the app and come back in the same activity and I want the button to be there. How do I do this? import android.app.activity; Import android.content.Intent; Importroid.os.Bundle; Import android.view.View; Import android.view.Window; Import android.view Windows Manager; Import android.widget.Button; Import android.widget.ImageView; Public class Udhanplan activity (button A, B ImageView; private boolean qualified; public Crete to zero (the bundle saved Instansstet) saved {Suprknkret (Instensstet); requestWindowFeature (Window.FEATURE_NO_TITLE); GetWindow (). Setflag ( WindowManager.LayoutParams.FLAG_FULLSCREEN, WindowManager.LayoutParams.FLAG_FULLSCREEN); setContentView (R.layout.flightplan); B = (Imag...
Read more

android - APK expansion file expPath does not exists -

-
Image
I am trying to change my app to use the APK extension file and for any reason given below The path can not be detected in the code passed. My APK Expansion Files ... static String [] getAPKExpansionFiles (Context ctx, int mainVersion, integer patchVersion) {Log.v (TAG, "Utils.getAPKExpansionFiles [27] mainVersion the" + Main version + "patch warsen =" + patch warsen); String packagename = ctx.getPackageName (); Logs. V (TAG, "Utils.getAPKExpensionFiles [27] package name [+ + + packagename +"] "); New vector of vector & lt; string & gt; (); if (. Environment.getExternalStorageState () equals (Environment.MEDIA_MOUNTED)) {Log.v (TAG, "Utils.getAPKExpansionFiles [32] MEDIA_MOUNTED"); // app to create the full path to expansion files file root = environmental .getExternalStorageDirectory (); log . V (tAG, "Utils.getAPKExensionFiles [35] root =" + root); Akspepath file = new file (Rutkstosting () + EXP_PATH + packageName...
Read more